Скачать или смотреть 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