When you want to apply a small tweak to the document, it must not require much time to Lock conditional field deed. This kind of simple action does not have to require additional training or running through guides to learn it. With the appropriate document editing instrument, you will not spend more time than is necessary for such a quick edit. Use DocHub to streamline your editing process whether you are an experienced user or if it is your first time using an online editor service. This instrument will take minutes to learn how to Lock conditional field deed. The sole thing required to get more effective with editing is a DocHub account.
A plain document editor like DocHub will help you optimize the amount of time you need to spend on document editing regardless of your previous knowledge of such instruments. Create an account now and increase your efficiency instantly with DocHub!
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