Change colour if cell is locked

G

Gary

Hi All

How can I use conditional formatting to modify the color
of a cell if it is locked?

Thanks in Advance.
 
D

Debra Dalgleish

Select the cell that you want to format (cell D4 in this example)
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =CELL("Protect",D4)
Click the Format button
Choose a colour on the Pattern tab
Click OK, click OK>
 
Top