How To Identify Or Highlight Expired Dates In Excel

In this tutorial i will show you how to quickly identify which products have been expired already. Yes. Sometimes we need to identify expired products so that we can remove them from the shelf but its hard to identify which ones are expired among a lot of dates if you are using an inventory system in excel. This is why i have created this tutorial hope you'll like it.
Lets get started:

Step 1: Select the cell range where you have written the dates among which you want to highlight expired date.
Step 2: Click on the conditional formatting.
Step 3: Click on new rules and then select "Use a formula to determine which cells to format"
Step 4: Write the formula in the formula bar (Formula is in the comment section)
Step 5: Click on format and select the color that you want to highlight with.
Step 6: Click Ok twice and done.

You have learned how to identify or highlight expired dates in Microsoft Excel using conditional formatting.
#IdentifyExpiredProducts #Date
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[Sam-cpeo]

Hi, how can I make this work with having gaps in my data?

[qaiserfayyaz]

How to highlight cells that has a date which has expired over a year ago and then also highlight that are about to expire in next 30 days?

[littleman]

Today is 3rd Feb 2023, but it is highlighting 28th Feb, 28th Apr 9th March 2023!