Lock Cells Based On Interior Colour Including Conditional Fomatting

Any cell with a light-grey displayed background (i.e. following conditional formatting) should be locked.

Any cell with a light-red/white displayed background should be unlocked.

The main complication arises from the fact that the displayed background of the cells will change based on the values in other cells (i.e. it will not always be the same cells that need to be locked).

Hi

IMHO, include all the conditions in the code and lock/unlock cells rather than depending on CF.