Can you use conditional formatting for if the cell contains xyz

[suprsnipes]

Hi,

Is it possible to use conditional formatting for "if the cell contains abc" then do xyz?

Regards,
suprsnipes

 

[xld]

Use a formula of

=ISNUMBER(SEARCH("Abc",A2))

 

[Matty]

Unclear. Could you embellish us with a little more detail?

Matty

 

[suprsnipes]

Brilliant, thank you very much!

 

[pgc01]

Hi

What's your excel version? In excel 2007- the conditional formatting has already an option "Format cell that contains".

 

[xld]

Unclear. Could you embellish us with a little more detail?

Matty

You select the cells you want to conditionally format, I am assuming the first is A2, then in CF you change Condition 1 to Formula Is, add the formula, then pick the format options.