by Kara Hiltz
You’re right. It’s difficult to get a handle on which cells you’ve protected and which cells anyone can edit freely. There’s no reason you should need to go through every cell in your worksheet and attempt to edit it – just to see if Excel locks you out. Imagine using that method in a worksheet with over a thousand rows!
Instead, you can use conditional formatting to apply a different color only to[…]