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?
Go to Solution.
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:
View solution in original post
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 @vinayvm 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
Best regards, Dominika
Thank you @vinayvm for help.