Lock/Protect Cells based on the color of cell

Hi Friends,

How do I lock/protect multiple range based on the color of cell. I have a sheet in which color of the range changes based on the values on another cell.


For example in cell A1 if the value is between 1-5 then the color of the range should become RED and the cells in the range should get locked/protected. And if the value of A1 is changed to 7 then the color of the range should become GREEN and user should be able to enter the value in the cells.

Thanks,
Nisha

Hi Speshul,

I would prefer locking the cell based on color of cell (because I am only using two color only ie Red and Green). Whereas if it is based on the value of cell, it will involve multiple conditions, as there may be different values entered by user, but the color of cell will always be RED or GREEN.
Kindly advice how to do it.

Thanks,
Nisha

Let me know your formula based on the number.

The conditional formatting do not have any function for locking/protecting the cell.

Thanks
Nisha

Can anyone help me with this formula.

Thanks,
Nihsa

Hi Friends,

Does anyone has a solution for this problem.

Thanks,
Nisha