Hi,
I would like to use conditional formatting but not for a set number that I type manually but rather for a different number from a column for the same item.
For example: sales 2021 column and sales 2020 column. I want to say make red if sales 2021 is less than sales 2020 column for the item.
hi @storme
Can’t you add a formula column to calculate the different between sales 2021 and sales 2020 and then apply conditional formatting in the formula column?
a quick test shows that basdebruin solution should work for your use-case storme
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.