If you want to apply a minor tweak to the document, it must not take long to Discard date log. This sort of basic action does not have to demand additional training or running through manuals to understand it. Using the appropriate document modifying resource, you will not spend more time than is needed for such a swift edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it is your first time making use of a web-based editor service. This tool will take minutes to figure out how to Discard date log. The only thing needed to get more productive with editing is a DocHub account.
A simple document editor like DocHub will help you optimize the time you need to spend on document modifying regardless of your previous experience with this kind of instruments. Make an account now and increase your productivity immediately with DocHub!
Hello everyone. Welcome to Excel 10 Tutorial. In this advanced Excel tutorial Im going to show you how to identify product that has expiry date within the next 90 days, Okay? in the previous video I have showed you how you can identify the product that has already expired and now in this video Im going to show you how you can identify products of which expiration that is within the next 90 days or next 120 days or your preferred given time slot, OK? And Im going to use conditional formatting to do this lets get started. First select the date range where you have written the expiration dates and click on the conditional formatting under the Home tab. Click on new rules now select this option use a formula to determine which cells to format and in the formula bar write this formula the formula will be in the comment section copy it from there and in this formula 90, this is the time range of upcoming expiration date and I am going to highlight all the product with yellow color cli