• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Protect cells if contain conditional formatting color


Active Member
Is it possible to protect (lock) specific range cells that contain color highlighted by Conditional Formatting.
These cells are variable.

It works from the dates in the calendar month.
When the year changes, the marked dates (weekends) also change automatically.
I want all cells belonging to the weekend and holiday dates to be locked automatically.
Please see attached example.

Is there any VBA code to solve this problem (or another way)?