Having full control over your documents at any moment is crucial to ease your daily duties and enhance your efficiency. Accomplish any goal with DocHub features for document management and hassle-free PDF editing. Access, adjust and save and incorporate your workflows along with other safe cloud storage services.
DocHub provides you with lossless editing, the possibility to use any formatting, and safely eSign documents without the need of looking for a third-party eSignature option. Get the most of your file managing solutions in one place. Consider all DocHub features today with your free of charge profile.
[Music] hello friends welcome back my name is free Andrew Kumar in this video you will learn how we can highlight consecutive duplicate in a selected range using conditional formatting so lets say here I have data wherein I have month wise sales you can see here I have duplicate math available so I want to highlight the month if it is coming in consecutively for example October is here and the second of two body is here then it should be highlighted because it is coming just after the previous one all right so what we can do we can use a conditional formatting here so I will select this range and Ill go to the home and conditional formatting and here I can go to the new rule now here I will go to the use of formula to determine which cell to form it and here we will use the formula to highlight D consecutive to click first of all I would like to tell you in the formula we need to put a logical formula which should return true or false only whenever your formula will return true then