Lock a row or column except today's date

[chandsu]

I want formula to lock a row or column except today's date with password protection.

Example

In A column I have dates and i have numbers in b column

If a person click on yesterday date row or future date row or column the user could not be modified the data in B Row or column

For any clarificaiton please revert

I would appreciated a quick response on the same.

 

[Yongle]

You could use Data validation

Select cell B2 \ click on Data Tab \ Data Validation
Create data validatiion with these settings in B2 (and copy or drag down)

Allow
Custom

Formula
=A2=TODAY()

Error Alter message
You cannot edit this cell
Column A is not today