Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Creating An Alarm Based On Date Expiry

  1. #1
    Join Date
    1st April 2005
    Location
    Thailand
    Posts
    145

    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
    Location
    Derbyshire,UK
    Posts
    18,429

    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 at 21:20.
    Hope that Helps

    Roy

    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 HELP
    Replies: 4
    Last Post: June 6th, 2007, 00:14
  2. VBA code for creating pop up alarm
    By kevin01 in forum EXCEL HELP
    Replies: 1
    Last Post: July 2nd, 2005, 02:41
  3. Program expiry date + passwords
    By FreddyKrueger in forum EXCEL HELP
    Replies: 2
    Last Post: June 9th, 2005, 19:56
  4. [Solved] VBA: Expiry date
    By LTT in forum EXCEL HELP
    Replies: 7
    Last Post: September 26th, 2003, 23:47
  5. Replies: 4
    Last Post: July 17th, 2003, 03:28

Bookmarks

Posting Permissions

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