View Single Post
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default 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.