Conditional Formating, contain space

[apache007]

Hi All,

How do I HIGHLIGHT a block of data that CONTAIN space??

For an Example, COLOUMN A1-A1000 contains TEXT data.
I would like to highlight those cells that contains data.

Thanks in advance.

 

[Gord Dibben]

New Rule>Use a formula.

=NOT(ISBLANK(cellref))


Gord Dibben MS Excel MVP