Forum Discussion
Solved
Conditional Formatting - formula for adjacent cells
Hello, Sorry for posting again but I got no response on my original post, so here I am trying again. If anyone could help me that would be great! I need to set up conditional formatting for a col...
Hi Noortje,
1) Format in red column B
2) Add rule for "green" condition as
3) Apply it to column B
Result is
Just be careful with absolute and relative regferences in the rule formula
Hi Noortje,
1) Format in red column B
2) Add rule for "green" condition as
3) Apply it to column B
Result is
Just be careful with absolute and relative regferences in the rule formula
Hi sorry dredged this up from a search as I need the same, it sort of works but where the numbers are the same it gets coloured but I need it to remain black if there is no change?
Hi Sergei,
I'm not too familiar with absolute and relative references so I didn't even think of that. It's working now!
Thanks so much for you help.
