Document editing comes as a part of many professions and jobs, which is the reason instruments for it must be reachable and unambiguous in their use. A sophisticated online editor can spare you a lot of headaches and save a considerable amount of time if you have to List highlight article.
DocHub is a great demonstration of a tool you can master right away with all the useful features accessible. You can start modifying instantly after creating an account. The user-friendly interface of the editor will help you to find and make use of any function right away. Notice the difference using the DocHub editor the moment you open it to List highlight article.
Being an integral part of workflows, document editing should stay straightforward. Using DocHub, you can quickly find your way around the editor making the desired alterations to your document without a minute lost.
hello everyone welcome to my channel excel sessions and today we will learn how to highlight cells if the cell data is available in a given list in this example we have a master list of items in column a and in column d we have another list now to highlight the cells in column d that contains item which is available in column a we will use conditional formatting so select the list of items in column d now go to home and under conditional formatting select new rule option in new formatting rule dialog select the last rule type and in the text box type equals to countif open bracket now select the master list items comma select the first item in the list and press f4 twice to convert into relative reference closing bracket greater than zero now click on format button select fill tab and select any color to highlight the cells click ok button click ok button now these cells that contains value which are available in the master list are highlighted so in this way you can quickly highlight