Good Morning Ron,

Thank you so much, it works You are the best!
-----Original Message-----
On Wed, 16 Jun 2004 13:44:59 -0700,

wrote:

Ron,

One other thing, the cell you B1 that I'm putting the
conditional formatting in, is blank if d13 =) my formula
is=IF(D130,"$","". Therefore, the below part of your
formula doesn't get rid of the border

Then I guess you must have a formula in B1, because if it
were truly blank, it
would evaluate to zero.

What is the formula?

If the formula leaves a null string in the cell, you
could either have it leave
a zero, or change the conditional formatting formulas to:

1. =AND(ISNUMBER(B1),B10)
2. =OR(B1="",B1=0)


--ron
.