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?

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?

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?

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?

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?

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?

Format all cell based on their value. Then "select" Minimum, and Number
and put in what the minimum value should be like .01 or whatever.

jmj713 wrote:

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?