Hi, after searching the web and testing VBA codes, I've become stuck... I have a Cell Range - E8:J27: where all cells have a fill color of RED, and can change to either WHITE or BLACK which is determined by conditional formatting. For the desired outcome I am not sure if the cell range should be set to locked, unlocked, or if the workbook being protected when opened will determine this. Workbook Details: VBA protected when closed. As a result, protected when opened. Protected with a password. Outcome Desired: RED = UNLOCKED WHITE = UNLOCKED BLACK = LOCKED BLACK cells can only be edited when workbook/worksheet is unprotected. Looped through all worksheets which all have the exact same layout, fill colors, conditional formatting, etc. Hopefully, I have explained this so someone can understand. If anyone could help me out with a code, it'd be greatly appreciated. Thanks in advance!

VBA to Unlock and/or Lock Cells (Determined by Cell Fill Color)?

Hi, after searching the web and testing VBA codes, I've become stuck...

I have a Cell Range - E8:J27:

where all cells have a fill color of RED,
and can change to either WHITE or BLACK
- which is determined by conditional formatting.
For the desired outcome I am not sure if the cell range should be set to locked, unlocked, or
- if the workbook being protected when opened will determine this.

Workbook Details:

VBA protected when closed.
- As a result, protected when opened.
- Protected with a password.

Outcome Desired:

RED = UNLOCKED
WHITE = UNLOCKED
BLACK = LOCKED
- BLACK cells can only be edited when workbook/worksheet is unprotected.
Looped through all worksheets which all have the exact same layout, fill colors, conditional formatting, etc.

Hopefully, I have explained this so someone can understand. If anyone could help me out with a code, it'd be greatly appreciated.

Thanks in advance!