Conditional Formatting

[cgmackenzie]

Hi,

I'd wondering how to conditionally format a cell that contains any text.

Thanks for the help.

Colin

 

[Special-K99]

So if A1 contains text format it in a specific way.


Select A1

Conditional Formatting
New Rule
Use a formula to determine...

=(ISTEXT(A1))

Format as required
Use Format painter (paintbrush icon) to copy to other cells

 

[cgmackenzie]

Worked like a charm.

Thanks!