I would like to lock cells in a spreadsheet against editing dependant on a value in another cell. Here is what I have:
Col A Col B
R1 Date 1 Value1
R2 Date 2 Value2
R3 Date 3 Value4
Basically I want to lock the changing of values in Column B if the corresponding date in Column A is before TODAY().
Is there any way that I can do this?
I would prefer to use basic Excel functions rather than macro/VB if possible.