[CT]

I have a list of numbers , some are 0's and there are some blanks. I want to
do conditional formatting on the numbers which is Ok but he blanks are also
showing the conditional formatting.

Is there a way around this?

[Bernard Liengme]

Try =AND(G1=0, NOT(ISBLANK(G1)))

You really are ahead of the game with Excel 3003 (grin)
Did Microsoft finally cure the chart problems of Excel 2007?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"CT" wrote in message
...
I have a list of numbers , some are 0's and there are some blanks. I want
to
do conditional formatting on the numbers which is Ok but he blanks are
also
showing the conditional formatting.

Is there a way around this?

[Stefi]

If you mean that numbers which are Ok are those greater than zero, then
select column (in this example column B) and enter this formula in CF formula
field:

=OR(AND(ISNUMBER(B1),B10),ISBLANK(B1))

Regards,
Stefi

€žCT€� ezt Ã*rta:

I have a list of numbers , some are 0's and there are some blanks. I want to
do conditional formatting on the numbers which is Ok but he blanks are also
showing the conditional formatting.

Is there a way around this?

[David Biddulph[_2_]]

The part of your message where you told us what conditions you are using for
the conditional formatting seems to have got lost in transit? :-(
--
David Biddulph

"CT" wrote in message
...
I have a list of numbers , some are 0's and there are some blanks. I want
to
do conditional formatting on the numbers which is Ok but he blanks are
also
showing the conditional formatting.

Is there a way around this?