If the cell is locked, then =CELL("protect") will return the value 1 (True)
If you want to Conditionally Format Un-Locked cells, then use the formula,
=NOT(CELL("protect"))
Try the =CELL("protect") formula in a cell to see the results 1 or 0
Discussion on:
Message 9 of 9
