What is currently in C5?

If a formula you could enter in C5 something akin to

=IF(ISNUMBER(B5),"",B5)


Gord Dibben MS Excel MVP

On Thu, 20 Sep 2007 11:54:02 -0700, audreyg
wrote:

How do I do it if I want the condition of C5 to be "Blank" instead of a
number value?

"Gary''s Student" wrote:

If we want to hide D5 if C5 has the value 1, use conditional formatting on D5
to Formula Is:
=C5=1
and pick the font color to match the background color.
--
Gary''s Student - gsnu200746


"audreyg" wrote:

Is there a way that you can hide the value of a cell depending on the value
of the cell directly in front of it?