Changing a color in a cell based on the text in another cell

R

Ryan

I am trying to change the color in a cell based on the text I enter in
another cell. EX. If I enter Arizona in cell B2 than cell B24 will turn red.
I need to do this for several answers, so B24 would need to change red if I
enter Arizona or Hawaii or Mississippi....ect.
 
D

Daniel.C

Use conditional formatting with formula :
=OR(B2="arizona",B2="hawai",B2="Mississippi") etc.
You can also consider lookup if you have somewhere a list of these
states.
HTH
Daniel
 
B

Bob I

Use Conditional Formatting. Formula is

=(B2="Arizona")+(B2="Hawaii")+(B2="Mississippi")
 
R

Ryan

Works Perfect!

Thank you.

Daniel.C said:
Use conditional formatting with formula :
=OR(B2="arizona",B2="hawai",B2="Mississippi") etc.
You can also consider lookup if you have somewhere a list of these
states.
HTH
Daniel
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete ROW based on Cell Contents 4
Change Color of cell 3
how to change color of cell based on contents of cell 2
Apply color of one cell to other 2
Changing the color of a cell based on the color of another cell. 6
Change Text Color in one cell based upon entry in referenced cell 3
Cell is colored(red0....based on this how to change other cell val 1
protect cell format 1

Top