Forum Discussion
Relative conditional formatting
Hello, I have multiple worksheets in Excel 365 that present data from one month to another. I am trying to make the data turn green if it's gone up since the previous month or red if it's gone down....
For February, you could use conditional formats with these formulas:
(RED)
=A2<January!A2
(GREEN)
=A2>January!A2
Make sure to apply the conditional formats to your necessary ranges.
Then for each month that follows just simply change "January" to the previous month.
