In Excel 2010, I want to use conditional formatting (to color the cell) if the cell is protected. Can you suggest the appropriate formula? I think it is IF(CELL("PROTECT").... something, but what?
You need a two step process
Happily there is a workaround to uses VBA for (2), we can use the XLM/Range Name approach to identify if the sheet is protected (see my article here) for further info on this method
To set-up for part 2
This range name will return 1 if the sheet is protected, 0 if it is unprotected.
You can now apply the conditional formatting
This rule is TRUE when the cell is both locked and protected (A16:I20 in the example below)