EXCEL 3003

[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

 

[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),B1>0),ISBLANK(B1))

Regards,
Stefi

„CT†ezt írta:

 

[David Biddulph]

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? :-(