Conditional formatting based on another cell [Solved/Closed]

Report
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
-
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

Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 24, 2020
135
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
thank you so much it helps. I appreciate that.