Use a formula of

=AND(A1<"",A1<0)

--
__________________________________
HTH

Bob

"jmj713" wrote in message
...
I need to use Conditional Formatting to shade a few rows on data based on
their value. Problem is there are cells with zeros and some are empty. I
need
to skip these cells. How can I do that?