Quote Originally Posted by Norie View Post
Running the macros with the workbook protected has never been mentioned, until recently.

As far as I can see the problem when the worksheet is protected is the checkbox's linked cell.
Pardon, worksheet. I said worksheet many many times now. I appreciate your effort, but please read. Your effort has produced very little help. In post #7... you said you had it fixed. I still don't see how you had it fixed. If you have a solution based on what you said there, please explain / post a link. In post #11, you say that in the video I posted, the formatting works. I have no clue how you see that... it certainly does not. The original problem of the cell being "stained" with the previous color remains. Then you posted your VBA based solution in post #12... without clarifying what the heck you did in post #7. Then you continued to push the VBA code idea... to which I explained was inadequate in post #17.

I'm sorry, but I think a problem here is that you don't read / listen to the problem.

No, your assessment is not correct that the main problem is with the checkbox's linked cell. Go ahead and remove the checkbox's linked cell. It makes no difference. Did you do what I asked?

Protect the worksheet and ONLY allow unlocked cells to be selected. NOTHING ELSE. Then close the file. Then re-open and try to run the macros.

The macros cannot run.

THIS IS THE PROBLEM. Not anything you have previously mentioned. I have the solution. Just use regular conditional formatting that is available on the "home" ribbon tab. However, this leads to another problem... i.e. the cell being "stained" with the previous color.