Forum Discussion
Relative conditional formatting
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.
Hi PReagan
That works but how do I copy paste it to the rest of my cells without it comparing to A2 but to the following cells automatically. If I want to compare A2 (january) with A2 (february), A3 (january) with A3 (february) and so on?
Thanks! 🙂
You may add in some cell of the each sheet the name of the previous sheet, let say in Feb!C1 it'll be "Jan", in Mar!C1 - "Feb", etc.
After that you may apply conditional formatting rule in Feb sheet with the formula
=A1>INDIRECT($C$1&"!"&ADDRESS(ROW(),1,4))(I started range from A1, otherwise adjust ROW() part)
By Format Painter you may copy this formatting on next sheets (Mar, Apr, etc)
Ok, so I think there is something I'm not understanding or it's just not working for me... Here is my worksheet... maybe that would help? Thanks again for your help guys! I really appreciate it! 🙂
So, I need to know if my score has increased or decreased since the previous month. All months have the same set-up... I've also attached it.
Please check attached. I created rule for Feb, added March sheet and apply same formatting to it by Format Painter. Sheet name is in F1.
- Make sure that the conditional format formula uses relative references (i.e. no $ signs) then in your case change the "Applies to" section to the range =$A$2:$A$50
