Forum Discussion
Conditional Formatting - how to minimize formatting rule duplication with editing
Hi all, I built a spreadsheet for management to track project deliverables, and am running into two issues. I attached a slimmed down version of the spreadsheet for review. 1. The file co...
I see what you mean my friend.
The solution is:
For column R >> in the Protection Tab of the Format cell Dialog box>> Uncheck "Locked" and Check "Hidden"
Hope that helps
Let me know to celebrate the success :)
Nabil Mourad
Hi Nabil, unfortunately this does not work, since unlocking the column then allows it to be written over by the end user. I will table this issue for now. I would still like help with the conditional formatting issue, if you are interested in trying to address that one. :)
