Crikey - three replies within minutes, most impressive and thank you all.

I've tried p45cal's conditional suggestion as I need Column H to contain hidden figures
that are used elsewhere and, I believe it works.

More checking will follow - in the meantime,

Many thanks to Dave Peterson, p45cal & Pete_UK

Kind regards

On 24/04/2010 21:27, 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