Announcement

Collapse
No announcement yet.

Creating An Alarm Based On Date Expiry

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating An Alarm Based On Date Expiry

    Hi guys

    I have a spreadsheet where in column A I enter a date. The date expires after 20 UK working days (4 weeks), I want the spreadsheet to give me an indication/alarm or something that the date has expired, maybe by turning the whole row a different colour or something. Any ideas?

    Thanks in advance

  • #2
    Re: Creating An Alarm Based On Date Expiry

    Use Conditional Formatting, eg to give a seven day warning in the Conditional Format Dialog Formula is box type
    =TODAY()>($A$1-7)
    Last edited by royUK; February 21st, 2007, 21:20.
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment

    Working...
    X