Lock Cells Based On Interior Colour Including Conditional Fomatting

[Admin]

Hi

Create a mockup by putting some dummy values. Be careful that the format of the sheet is same in the mockup version as well.

[AerosAtar]

I have attached a stripped-down version of one page of the form.

Book1.xlsm

All of the code for the Command Button Click() events have been stripped out, since they won't work anyway without the rest of the workbook (not to mention being irrelevant to what I am asking about), and I have removed passwords, etc.

Hopefully this helps show what it is I need/want to accomplish.