Do you need the <"" condition?
If the cell is empty or contains "", would it satisfy =and(a1=5,a1<=20) ?
--
David Biddulph


Fred Smith wrote:
In A1, enter:
=and(a1<"",a1=5,a1<=20)

Copy the format to the other cells.

Regards,
Fred

"apache007" wrote in message
...
Hi All,

Let say I have data Coloum A1:A100 containes number data
and I want to HIGHLIGHT using Conditional Formatting, 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.