Conditional Formatting, 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 SPACE.

Thanks in advance.

Conditional Formatting, contain SPACE
 

under conditional formatting, choose Formula is, and enter
=NOT(ISERROR(FIND(" ", A1)))

Hope it helps,
eksh

"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 SPACE.

Thanks in advance.

Conditional Formatting, contain SPACE
 

Thank you Eksh !!

Need more help here for the newbie.

Let say I have data Coloum A1:A100 containes number data
and I want to HIGHLIGHT those cells that have the following criteria:

1. Is not empty
2. Has a value between 5 and 20.

I don't know the formula for Criteria #2.

Thanks.


"eksh" wrote:

under conditional formatting, choose Formula is, and enter
=NOT(ISERROR(FIND(" ", A1)))

Hope it helps,
eksh

"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 SPACE.

Thanks in advance.