Conditional Format - 1 Cell to change color

[bobgrand]

Hello all,

How do conditional format A1 to change color if a specific word is somewhere in Column A?

Greatly appreciate any help

Bob

 

[DanteAmor]

Select cell A1
Then, click Home > Conditional Formatting > New Rule.
In the New Formatting Rule dialog box, click Use a formula to determine which cells to format.
Under Format values where this formula is true, type the formula:

=COUNTIF($A:$A,"[COLOR=#0000ff]some[/COLOR]")>0

Click Format.
Select Color.
Click OK.
Click OK.

Change "some" for the word you want