Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 2 of 2

Thread: Creating An Alarm Based On Date Expiry

  1. #1
    Join Date
    1st April 2005

    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

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    26th January 2003

    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
    Last edited by royUK; February 21st, 2007 at 21:20.
    Hope that Helps


    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Date Expiry And Workbook_open
    By diodorus in forum Excel General
    Replies: 4
    Last Post: June 5th, 2007, 23:14
  2. VBA code for creating pop up alarm
    By kevin01 in forum Excel General
    Replies: 1
    Last Post: July 2nd, 2005, 01:41
  3. Program expiry date + passwords
    By FreddyKrueger in forum Excel General
    Replies: 2
    Last Post: June 9th, 2005, 18:56
  4. [Solved] VBA: Expiry date
    By LTT in forum Excel General
    Replies: 7
    Last Post: September 26th, 2003, 22:47
  5. Replies: 4
    Last Post: July 17th, 2003, 02:28


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts