+ Reply to Thread
Results 1 to 3 of 3

Suspense Notifications

  1. #1
    Tricky
    Guest

    Suspense Notifications

    Can I set up an excell spreadsheet to notify me when a suspense goes overdue?

  2. #2
    Forum Contributor
    Join Date
    01-11-2004
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    388
    Hi!

    I don't know your context, but you can use conditional formating to colour cells if the date in them is earlier than today's date (as held in your computer). Would this help?

    Alf

  3. #3
    Dave Peterson
    Guest

    Re: Suspense Notifications

    Maybe you could put a formula in an adjacent cell to the due date.

    =IF(A1<TODAY(),"Overdue","ok")

    Format it big, bold, red letters.



    Tricky wrote:
    >
    > Can I set up an excell spreadsheet to notify me when a suspense goes overdue?


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1