conditional format works if not ="" or AC5<"" but if a formula
returning a null is present, then that does not work. what do you enter if
there is a formula present :) thanks.

=LEN(AC5)=0

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"nastech" wrote in message
...
conditional format works if not ="" or AC5<"" but if a formula
returning a null is present, then that does not work. what do you enter
if
there is a formula present :) thanks.

try counta(a1)=1
counta() counts functions resulting in "".
countblank

"nastech" wrote:

conditional format works if not ="" or AC5<"" but if a formula
returning a null is present, then that does not work. what do you enter if
there is a formula present :) thanks.