You could use conditional formatting, with a formula of =ISERROR(A1) and set
the font colour to white.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"dgraham" wrote in
message ...
Hi,
I have cells showing #VALUE!, because the cell it is referencing is
blank (i think this the cause), is there a way for it not to show. I
have used IF statements in the past for simple formula's but the
formula for this is a bit complicated (thanks Biff), thanks for any
assistance.
Regards
David
--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161