Microsoft Excel Functions & Formulas

Use the CELL function to detect unlocked cells

If a worksheet has been protected, all cells are locked by default.

The protection for each cell has to be unlocked before activating

sheet protection. If a sheet is protected, usually it is not possible to

see at one glance which cells are locked and unlocked. Use condi-

tional formatting to shade all unlocked cells in a range.

4

To shade unlocked cells:

1. Create the worksheet shown in Figure 10-22 and unlock

cells B2, B4, B6, and B8.

2. Select cells A1:D10.

3. On the Format menu, click Conditional Formatting.

4. Select Formula Is and type the following formula:

=CELL("protect",A1)=0.

5. Click Format.

6. F