Conditional Formatting


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.