Forum Discussion
Relative conditional formatting
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.
- Wow Sergei, Thank you soooo much for your help! I've wasted so much time trying to figure this out! You're a life saver and I'll mention that you helped me to my boss, haha! Have a great day!