ExcelBanter - Conditional Formating, contain space

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formating, contain space (https://www.excelbanter.com/excel-discussion-misc-queries/255280-conditional-formating-contain-space.html)

apache007

Conditional Formating, contain space

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

Conditional Formating, contain space

New RuleUse a formula.

=NOT(ISBLANK(cellref))

Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 15:51:01 -0800, apache007
wrote:

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.

All times are GMT +1. The time now is 11:52 PM.