Excel: Show unprotected cells

In this article, you will learn how to color-display unprotected cells in Excel.

The formula for success - this is how you can display unprotected cells in Excel

1. Open the Excel document in which you want to display the unprotected cells. Then select the area in which you want to display the unprotected cells.
2. Click on the "Start" tab and select the "Conditional Formatting" entry. Then click on "New rule" in the context menu.
3. A window opens with the name "New Formatting Rule". Select the rule type "Use formula to determine cells to format".
4. Under "Format values ​​for which this formula is true:" enter the formula = CELL ("Protection"; A1) = 0. Then click "Format ..." and select a color in which unprotected cells are to be displayed.
5. Click "OK" to apply the settings. Shortly afterwards, the unprotected cells will be displayed.

This practical tip shows you where you can find other useful Excel exercises.