if not empty, not a formula?
 

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.

if not empty, not a formula?
 

=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.

if not empty, not a formula?
 

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.