How to identify or highlight expired or upcoming dates in Excel? - Excel Tips and Tricks

Learn how to identify or highlight expired and upcoming dates in Excel is important for a lot of retails stores from supermarkets to sale departments to computer parts store. It will help the staff identify items that are expired or about to be expired so that that can be sold at sale price.

Below is a very generic steps on how to create whatever you application maybe.
Today's Date
1) Select "Today's Date" cell.
2) Function
=today()

Days Left
1) Select first cell under "Days Left" column.
2) Function
=B6-$B$1
3) Apply to all rows.

Status
1) Select first cell under "Status" column.
2) Apply to all rows.

Conditional Formatting Status Column
1) Select the "Status" column dataset.
2) Conditional Formatting
3) Highlight Cells Rules
4) Text that Contains...
5) Enter "Expired" and "Light Red Fill with Dark Red Text".
6) Steps 2 to 4.
7) Enter "Warning" and "Yellow Fill with Dark Yellow Text".
8) Steps 2 to 4.
9) Enter "On Time" and "Green Fill with Dark Green Text".

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

[mos]

Your technique are awesome but please provides the files too so we can practice on it as I am new to excel

[orangeknight]

We have to manually input the Expired cell (under Today)?

[jdvxeft]

Its good, but my query is when we make the payment on time. Then the days left column supposed to be blank.

[orangeknight]

Why did you turn them into absolute references?