Conditional Lock Cell

**Giah98** · 10-20-2008, 04:46 PM

Hello,

I'm new to programming and I have been looking on how to create a simple worksheet for a hotel manager where I can lock two different cells when another cell has entry. (It's pretty much showing that when a two bedroom is reserved, the one bedroom and hotel room beside it cannot be reserved.) I included an attachment. For example, is if B36:F36 (or merged together with entry) has an entry then B15:F15 and B31:F31 become locked and cannot enter in these cells.

Is it possible to add a box that is required to fill out when entering in these rows B35:AE38 so when a those cells are entered (two bedroom is reserved) a pop up window will show up when you select the reflecting hotel rm or one bedroom?

Would there be an easier way to do the conditional lock other than using Macro?

**Kieran** · 10-21-2008, 12:45 AM

Giah98,

you appear to ahve tried thsi with conditional fomatting already.
Try cahnging the fomula in the conditional format in cell b15 to =B36<>"" and try again - that may be a better way to show it.
It does not however lock the cell.

That can only really be accomplished with VBA.

**royUK** · 10-21-2008, 04:14 AM

You cannot lock a cell with a formula or Conditional Formatting. I can't follow what you mean, your worksheet doesn't look very user friendly to me.

**Giah98** · 10-23-2008, 03:38 PM

The spreadsheet is simple, dates are on top, type of hotel room on the left column. Here's what I want to show. If someone reserves the first two bedroom suite, the first one bedroom suite (rm#: 101)and first hotel room (rm#: 102) are combined to create the two bedroom suite for that reservation. I want to make the spreadsheet to lock the first one bedroom suite (rm#: 101)and first hotel room (rm#: 102) when someone books the two bedroom to avoid double or triple booking. Is that explained better?

**royUK** · 10-24-2008, 02:41 AM

What's wrong with the conditinal formatting that youare using?

**Giah98** · 10-24-2008, 09:42 AM

The conditional formatting currently just greys the two corresponding hotel rooms. I would like it to grey, lock the cell (so no one can make a reservation for those rooms when the 2 bedroom is reserved, or add data into those cells), and if possible when you select the greyed cells it would pop up a message saying "the 2 bedroom is reserved, this will cause double booking" or something like that.