Conditional format depending on protection
Posted on 2011-05-10
This is not a must have, but I would like to be able to set the format of a cell dependant on whether ther Worksheet has protection turned on.
I had hoped to be able to do this via Conditional Formatting - but cannot fugure out a syntax for the formula to use.
Any suggestions gratefully received.