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 15, 2014 at 05:17 AM
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 - Dec 17, 2014 at 11:22 PM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 15, 2014 at 07:55 AM
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
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 15, 2014 at 11:27 PM
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
0
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Dec 17, 2014 at 12:29 PM
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
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 17, 2014 at 11:22 PM
thank you so much. that helps me a lot.
1
ArashMan Posts 41 Registration date Monday December 15, 2014 Status Member Last seen February 18, 2015 1
Dec 15, 2014 at 11:27 PM
EXAMPLE
0