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 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.