Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I would like to know if I am able to protect and unprotect a range of cells based on the date in another cell. For example: Cells N13:N22 are for a period between 21Aug and 23Aug and Cells N27:N37 are for a period between 25 Aug and 27 Aug. Today's date would be in Cell A1. I wish to be able to unprotect Cells N13:N22 when Cell A1's value is equal/greater than to 21Aug and re-protect them on 24Aug. Thanks in advance ----------- Abes Western Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |