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
-
i want to type a name in cell B3. and I want the cell's color change when I type 1,2 or 3 in B6 cell by using conditional formatting. is that possible?

4 replies

Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 24, 2020
135
ArashMan, Good morning.

Try to use:
Apply Conditional Formatting to B3 cell using formula.

=OR($B$6=1,$B$6=2,$B$6=3)

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
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
Dear Mazzaropi
thank you for your respond
but this wont helps. is next picture what you mean?
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 at any time without any effect on the color of B3 cell
Posts
1834
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 24, 2020
135
ArashMan, Good afternoon.

"...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 at any time without any effect on the color of B3 cell..."


Now your explanation is clear and precise.

Take a look at an example I did for you:

http://speedy.sh/GZFAM/17-12-2014-en-Kioskea-Conditional-Format-OK.xlsx

ATTENTION:


Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
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. that helps me a lot.
Posts
41
Registration date
Monday December 15, 2014
Status
Member
Last seen
February 18, 2015
1
EXAMPLE