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

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.

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

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

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.

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

Use Conditional Formatting. Formula is

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


Ryan wrote:

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.

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

Works Perfect!

Thank you.

"Daniel.C" wrote:

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

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.