Having complete control over your documents at any time is crucial to alleviate your day-to-day duties and enhance your productivity. Achieve any goal with DocHub features for papers management and convenient PDF file editing. Gain access, adjust and save and incorporate your workflows with other safe cloud storage services.
DocHub offers you lossless editing, the opportunity to use any format, and securely eSign documents without having searching for a third-party eSignature alternative. Get the most of the file managing solutions in one place. Try out all DocHub functions today with the free of charge profile.
hi in this video Im going to show you how you can highlight automatically your date in function of the date of today for instance in this example when the date in currency is lower than the date of today in current D automatically the color is not the same and when the gap is between zero day and three days my first gap so color is blue between four and seven days its orange and after its red and this is linked to the setting of your computer so for instance here as you can see Im Monday 7 August 2017 so value in column D but if I change this value and I put for instance four you will see that automatically all my date and colors will change like this and that automatic because the gap between today and the date in currency is different now automatically the color change and Im going to show you this but watch out if you need is this that means the way to calculate the gap between today and the next birthday the logic is not the same so before to subscribe to the video take a loo