# 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
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
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
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
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.
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