Excel Guides

How to Visually Show a Protection Status in Excel

There are a few ways to show protection status in Excel. One way is to use conditional formatting.

To do this, first select the cells you want to format. Then, go to the Home tab and click on Conditional Formatting in the Styles group. In the drop-down menu, select Highlight Cell Rules and then choose Equal To.

In the next dialog box, enter the value that you want to format cells equal to. For example, if you want to format cells that are protected, you would enter "TRUE" (without the quotation marks).

Click on the Format button and choose the fill color you want. Then click OK twice.

Now all of the cells that are protected will be filled with the color you chose.

Another way to show protection status is with a formula.

Let's say you have a range of cells named "Protected" and another range named "Unprotected". You can use a simple IF function to show which cells are protected and which are not:

=IF(Protected=TRUE,"Protected","Unprotected")

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.