I am working on a project that requires locked cells based on how the cells are conditionally formatted. In this instance the conditionally formatted cells have interior color 15.
This is the rule I am using for the conditional formatting:
FORMAT: Interior Color Code 15
I need a VBA code that will lock all the cells on the entire sheet that have that conditional formatting applied. Since the color of the cells is based on a conditional format, none of the VBA codes I can find will recognize the color.
Can anyone help?