Jump to content

Build Theme!
  •  
  • Infected?

WE'RE SURE THAT YOU'LL LOVE US!

Hey there! :wub: Looks like you're enjoying the discussion, but you're not signed up for an account. When you create an account, we remember exactly what you've read, so you always come right back where you left off. You also get notifications, here and via email, whenever new posts are made. You can like posts to share the love. :D Join 92320 other members! Anybody can ask, anybody can answer. Consistently helpful members may be invited to become staff. Here's how it works. Virus cleanup? Start here -> Malware Removal Forum.

Try What the Tech -- It's free!


Photo

Help with locking cells ..until


  • Please log in to reply
1 reply to this topic

#1 scudo

scudo

    Silver Member

  • Authentic Member
  • PipPipPip
  • 427 posts

Posted 05 February 2012 - 08:33 AM

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

    Advertisements

Register to Remove


#2 Ax238

Ax238

    Advanced Member

  • Visiting Tech
  • PipPipPipPip
  • 716 posts

Posted 29 February 2012 - 12:55 PM

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

Related Topics



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users