Forum Discussion
How can I copy Conditional Formatting on cells below while the formula changes along?
I have made a simple Excel spreadsheet for myself so that I can easily see who I've sent a connection request, who has accepted the request, who I've contacted and who has reacted positively. For eac...
Hi Giel,
You may create 4 conditional formatting rules, one for each color, with formulas
for red
=$G2=1
and apply it to your range in B, e.g. $B$2:$B:$100
Same for other colors
Thanks for your help Sergei!