Conditional formatting based on another cell [Solved/Closed]

ArashMan 41 Posts Monday December 15, 2014Registration date February 18, 2015 Last seen - Dec 17, 2014 at 01:46 AM - Latest reply: ArashMan 41 Posts Monday December 15, 2014Registration date February 18, 2015 Last seen
- 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
See more 

2 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Dec 17, 2014 at 01:10 PM
2
Thank you
ArashMan, Good afternoon.

This doubt was solved in your other post.

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

I'm changing this status post to SOLVED.

Thank you, Mazzaropi 2

Something to say? Add comment

CCM has helped 1662 users this month

ArashMan 41 Posts Monday December 15, 2014Registration date February 18, 2015 Last seen - Dec 17, 2014 at 11:23 PM
0
Thank you
thank you so much it helps. I appreciate that.