• 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.

Lock Cells based on color


New Member

I would like to use conditional format or VBA code to lock the formula based on color index 808080. I tried some VBA script but it is giving me a range error. Can someone can help with this.


Excel Ninja
So what is your current code? I'd recommend uploading sample workbook along with code with desensitized info. So it's clear to us what exactly you are trying to do.