| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I color a cell based on cell text | Excel Worksheet Functions | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
| Changing background color based on different cell | Excel Discussion (Misc queries) | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
Linear Mode
