Lock rows of cells based on a date value in one cell

Chrisander A G Ravna 20 Reputation points
2023-07-09T07:02:02.3966667+00:00

I`m looking for a way to lock or freeze a set of rows from getting edited based on a date value in one cell.

In this example I need to freeze the marked rows when the date in the left most cell is one week old. Freeze the rows of cells when its 9. january.

User's image

Microsoft 365 and Office | Excel | For business | Windows
{count} votes

Accepted answer
  1. Sukanya Mukherjee 90 Reputation points
    2023-07-09T14:57:12.6366667+00:00

    Conditional Formating_Data Validation_1

    Conditional Formating_Data Validation_2

    Conditional Formating_Data Validation_3

    Conditional Formating_Data Validation_4

    Conditional Formating_Data Validation_5

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Sukanya Mukherjee 90 Reputation points
    2023-07-10T12:21:02.69+00:00

    Hi !, You can try it with Excel VBA code

    Right now I am trying to resolve , it will take time,

    Hope it helps

    Thanks

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.