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