Conditional formatting based on another cell

Solved/Closed
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 17, 2014 at 01:46 AM
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 17, 2014 at 11:23 PM
Hello,

this is what I want:
EXAMPLE:
B3= Arash
if B6=1 then B3 goes red
if B6=2 then B3 Goes yellow
and if B6=3 then B3 goes green
i want to change B3(Arash) at any time without any color effect on B3 cell.
thanks for your help

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Dec 17, 2014 at 01:10 PM
ArashMan, Good afternoon.

This doubt was solved in your other post.

https://ccm.net/forum/affich-783193-conditional-formatting-based-on-another-cell#4

I'm changing this status post to SOLVED.
2
ArashMan Posts 38 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 17, 2014 at 11:23 PM
thank you so much it helps. I appreciate that.
0