Conditional Formatting on LISS
I created a module that has a lot of line items and corresponding values in 3 Versions (FCST, Budget, Variance).
I need to mark the Variance column in red when the Variance has minus value for a subsequent line items.
PS. Variance is part of LISS from source module
Can you please suggest me what I should do in this case?
Still you can follow the same principle.
Each of the lineitems needing conditional formatting (which have different drivers) will need a separate Conditional Formatting lineitem as shown:
You could achieve this by creating lineitems which you can use for conditional formatting, as shown in the below example. Hope you can extend this to your case:
"Value" is the data lineitem which is formatted using the lineitem 'CF' (shown in another view below).
Conditional formatting rule:
Thank you @Vinay VaradarajM for your reply, my case is little more complicated.
I need to have the attached line items because they have a different format (%, normal number) -see the following photo:
Sales, Mat.Exl.Freight, Memo:Freight... - line items
Forecast, BBP, Variance - Line Item Subset
Thank you @Vinay VaradarajM for help.