EXCEL 3003

C

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

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
 
S

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:
 
D

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