You know you are using the right document editor when such a basic task as Lock up highlight paper does not take more time than it should. Modifying documents is now a part of numerous working operations in various professional fields, which is why convenience and efficiency are essential for editing tools. If you find yourself studying tutorials or searching for tips about how to Lock up highlight paper, you might want to get a more easy-to-use solution to save your time on theoretical learning. And this is where DocHub shines. No training is required. Simply open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Make use of this instrument to complete the paperwork you need in short time and get your productivity to another level!
hi guys welcome back to my channel MIT to do it if youre new to this channel please consider subscribing Ive been posting a lot of Excel tutorials these days which will help you in your day to day activity so lets get started with this video in this particular tutorial Im going to teach you how to highlight locked or unlocked cells using conditional formatting so I have a sample data set here Im going to quickly select my data and unlock all the cells which are here by going to format cells protection and Im going to unlock all of these cells for now and then Im going to lock these many cells here for the sake of this tutorial Im going to click on format cells again Im going to lock the cells and click on OK now Im going to select this data and I will click on conditional formatting and click on new rule click on use a formula to determine which cells to format and over in this section here you need to type in the formula is equals to cell open bracket open quotes and type i