Conditional formatting based on another cell

Solved/Closed
ArashMan
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
- Dec 17, 2014 at 01:46 AM
ArashMan
Posts
41
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 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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
41
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