Get Mystery Box with random crypto!

If you often use sheet protection in your files, then you may | Excel Today

If you often use sheet protection in your files, then you may have encountered such a task. You need to quickly find out in which cells of the range protection is enabled (there is a checkmark "Protected cell" on the "Protection" tab in the "Format cells" window), and in which not.

Manually checking each cell is clearly not an option. But you can use conditional formatting and the CELL function, which can check if protection is enabled. Simple, fast and clear.

Read more about the sheet protection in the article