Locking a range cell which is in past date, present and future date cell should be active

[chandsu]

Hi All,

Kindly help on the below

I have excel sheet which update the daily productivity of the different user for different process in a same sheet. What happens is the user update the daily productivity, sometimes they add extra volume or change the productivity details which is in the past dates which mismatch with other reports which is tracked in another sheet which leads to re check every month end. To avoid this i want to lock the cell for the past date productivity and they should not able to edit or overtime. Only one user should have access to edit the past date productivity details of the past date.

Present date and future date cells should be activity. I hope you understand what i am requesting, I have already requested this but i could not found my old post which already requested which 9 years back post. if you could get my old past is also much appreciated or if someone can help on the above also much appreciated.

Kindly someone help at the earliest is much appreciated.

Examples:-
[TABLE="width: 600"]
<colgroup><col><col><col span="7"></colgroup><tbody>[TR]
[TD="colspan: 4"]User 1[/TD]
[TD] [/TD]
[TD="colspan: 4"]User 2[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]P1[/TD]
[TD]P2[/TD]
[TD]P3[/TD]
[TD] [/TD]
[TD]P1[/TD]
[TD]P2[/TD]
[TD]P3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]01-Mar-18[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]02-Mar-18[/TD]
[TD]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[TD] [/TD]
[TD]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]03-Mar-18[/TD]
[TD]3[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]04-Mar-18[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05-Mar-18[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]06-Mar-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]07-Mar-18[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

Regards,
Sumesh C