Change colour if cell is locked

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi All

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

Thanks in Advance.
 
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>
 
Back
Top