Forum Discussion
Highlight or lock cells based on a date condition
I'm creating a resource capacity plan and I'm trying to lock or highlight (in grey) cells from columns K-Z depending on columns C and D. So for example project A starts in Sept 22 and ends in Sept 2...
Lock or unlock specific areas/cells of a protected worksheet
By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it's possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.
More informations will find in the upper link.
I know I don't know anything (Socrates