How to set up alarm for cell has entry as date when it expires?

V

Vinod Menon

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.
 
R

Rowan Drummond

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
 
Top