Change of Colour to a cell when "Warning" is in that cell

S

Striker

After some help.
Say in column D i want all the cells with the word "Warning" to b
yellow, all the cells with the word "Normal" to be green. I think
have to write a Visual Basic script, but i dont know how to. I need i
to automatically update when the words move, so it needs to be live
 
J

JRocket02

Use Format > Conditional Formatting. In the detail window change the mode
to formula-based, and then write a formula such as "If $D$1 =
"Warning",TRUE,FALSE). Then you can change all the formatting for when this
condition is true, such as changing the text color to red. If the word
changes later, and hence the condition fails, then the default formatting
will replace the conditional formatting. Excel is also smart enough that if
you define conditional formatting in one cell and then either drag (copy)
the cell down or use paste > special and choose formatting, the formulas
inside conditional formatting will change to refer to the target cell. In
other words, you only have to define different conditional formatting when
the condition or the desired format changes. So long as you want the same
thing down the entire column, just define it once and then copy the cell
down the column.
 
Top