Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to set up alarm for cell has entry as date when it expires?
I am entering Certificate dates on a Microsoft Excel sheet. I would like an
alarm, like a red band, on the cell, when the date has passed, in other words when the Certificate has expired. |
#2
|
|||
|
|||
How to set up alarm for cell has entry as date when it expires?
Use conditional formatting (look it up in Excel help). You will want to
use a formula in the conditional formatting like =A1<today() Hope this helps Rowan Vinod Menon wrote: I am entering Certificate dates on a Microsoft Excel sheet. I would like an alarm, like a red band, on the cell, when the date has passed, in other words when the Certificate has expired. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Automatically enter today's date as a static entry | Excel Worksheet Functions | |||
Cell converts a date entry to "=" and displays "01/00/00 | Excel Worksheet Functions |