"Fred Smith" wrote:
No, but the OP asked for it, so I thought I would
show how to check for non-blank.

But if it's superfluous, we can educate the OP on that point.

There is never an instance where AND(A1<"",A1+5=B1,...) does what you (or
the OP) might think it does.

See my more detailed explanation in a response to your later posting.


----- original message ------


"Fred Smith" wrote in message
...
No, but the OP asked for it, so I thought I would show how to check for
non-blank.

Regards,
Fred

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.