Conditional formatting on variance versions

Guido.kaandorp

Hi, I would like to apply conditional formatting on a dashboard. I have a module based on 3 versions.

-Actual

-Annual Plan (AP)

-Variance

 

Variance = Actual - AP

 

Now the conditional formatting should be green if the Variance >0 and red when <0. However when I apply conditional formatting all versions will be formatted.

I have tried the following to add an extra line item for the sake of the conditional formatting only, which results in a 0 value for the actual and AP version and with (potentially) a negative or positive number for the Variance version. However this would not help as the Variance version is overridden with the version formula (Actual- AP).

 

Any tips or trics will be appriciated.

nathan_rudman

Hello,

If you are using the variance version, adding an additional line item as you did might be the only way. Link your second line item to the first one, you should get the same values on the three versions. Then you can apply the conditional formating on the second line item only and hide the columns you don't want showing.