1 reply to this topic

[scudo]

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

[Ax238]

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