Conditional Formatting: allow conditions to reference another column
S
Sam Arora
Can we please add a yellow colour anytime the "total for current month" is more than $*** different +/- to "Total for previous month" column?
It's affecting us from getting benefit our of BI platform as a result.
Log In
Micus
Hi Sam Arora,
Would this workaround work for you?
- Add one more column next to the one you want to highlight
- calculate the difference in this column
- highlight this column by the difference
So the cells highlighted in the new column can be a indicator of the previous column, and people can also read the difference.