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...
=(K$2<=EOMONTH($C3,-1))+(K$2>$D3)In order to highlight cells you can try this rule for conditional formatting.
=$K$3:$Z$7This is the range the format applies to in the example.