Forum Discussion
conditional formatting rules depending on other value from different column
I am wondering if it is possible to get the rules from background conditional formattting depending on a value from another column. So as you can see under neath I got these rules for a specific tab...
You can create a new measure which returns a value based on the comparison between the result and the target.
I'm not sure if doelstelling is a column or a measure, but if its a measure then something like
Background colour measure =
var currentValue = CALCULATE( [Vertrek niet te laat] )
var targetValue = CALCULATE( [doestelling] )
return IF( currentValue >= targetValue, 1, -1)Then in your background formatting function you can set green if the value is 1 or red if it is -1
'doelstelling' is not a measure, but I made it a measure and now it works with your code, thank you!