LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Is this possible?

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"