When you want to apply a minor tweak to the document, it must not take long to List highlight form. Such a basic action does not have to demand extra training or running through manuals to learn it. Using the proper document editing resource, you will not take more time than is needed for such a swift edit. Use DocHub to simplify your editing process whether you are a skilled user or if it is your first time using an online editor service. This tool will require minutes to learn to List highlight form. The only thing needed to get more effective with editing is a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to devote to document editing irrespective of your prior knowledge about this kind of instruments. Create an account now and increase your productivity immediately with DocHub!
in this video well look at how to compare two lists using conditional formatting this is a great way to visually highlight missing items in a list here we have two lists both lists contain the same number of items but each list is slightly different we can use conditional formatting with a formula to quickly find and highlight the differences first Im going to name each list the first list Ill call list 1 and the second list Ill call list 2 its not necessary to name the lists but it will make our formulas easier to read and understand for the formula we can use the countif function countif takes two arguments a range and a criteria we can use count if to count the number of times that each item in list 1 appears in list 2 if count if returns zero we know the item is not in list two this will work perfectly for conditional formatting since we can easily flag items where the count is zero with a formula for the first rule Ill select list 1 and create a new conditional formatting r