Help with locking cells ..until

I am looking to do this without using macros, so some sort of formula if possible. I have cell D4 which the user enters a start date. They would then complete C1:C6 (as dates) Is there a way to lock out or hide any entry if D4 has not been completed. I was thinking if D4 blank then any entry in C1;C6 would match the colour background so invisible. Just dont know how to do it, tried conditional format but didnt work. thanks

Hi scudo!

You can do it with conditional formatting. In Excel 2007:

• Click Conditional Formatting | New Rule… from the Home tab
• Choose "Use a formula to determine which cells to format"
• Set the format (e.g. maybe set the text to white)
• Set the formula to the following:
  

  =ISBLANK(D4)

I tested and this does work as expected, the text will be clear if D4 is blank.

Regards,

Ax