You could use format|conditional formatting to hide that value.

Or you could change the formula:
=if(count(h2,c3,b3)<3,"",(h2+c3-b3))

But if you want to try...
Select H3:Hxxx
and with H3 the activecell
Format|conditional formatting (xl2003 menus)
Formula is:
=count(h2,c3,b3)<3
And give the cell a white font color

I'd change the formula in the cell. Even though all 3 values are not entered,
you may find that the hidden value changes other cells that shouldn't be changed
until all 3 are entered.

And it can be a bear to find these magic values that are hidden with conditional
formatting <vbg.



Peter wrote:

Hello experts,

I have been trying to resolve the following:

In an (excel 2002)worksheet, column H contains a series of formulae eg:

In H3 is (H2+C3-B3) - it continues down to H500. Column A is formatted for date entry from
A1 to A500.

If A4 and the remainder have yet to have dates entered, I'm trying to change the font
colour of H4 (through to H5000) to white i.e. whilst the column is populated, the values
are not shown. I hope this makes sense.

Is this possible without using VBA and, if so, can anyone please help with the necessary
formula?

Regards

Peter

--

Dave Peterson