If you want to apply a minor tweak to the document, it must not require much time to Lock conditional field invoice. This type of basic activity does not have to demand extra education or running through guides to learn it. With the appropriate document modifying tool, you will not spend more time than is needed for such a swift change. Use DocHub to simplify your modifying process whether you are an experienced user or if it’s the first time using an online editor service. This instrument will take minutes to learn how to Lock conditional field invoice. The sole thing needed to get more effective with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the amount of time you need to spend on document modifying no matter your prior experience with such tools. Make an account now and boost your efficiency immediately 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