I am. Hopefully someone else with Excel 2007 can. Thanks.

"David Biddulph" wrote:

Are you using Excel 2007? If so, I can't help you.
--
David Biddulph

"jmj713" wrote in message
...
I currently have a simple Highlight rule, "Format all cells based on their
value", with the lowest colored red and the highest colored green. Where
do I
need to include the formula to skip zero and empty cells? When I change
the
Type to "Formula" and enter the formula provided in the preceding post,
Excel
gives me an error, saying "You cannot use relative references..."

"David Biddulph" wrote:

Use AND or OR functions as appropriate in your CF Formula Is condition.
What criterion are you currently applying?
--
David Biddulph

"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?