Results 1 to 6 of 6

Conditional format for overdue date

Threaded View

  1. #1
    Registered User
    Join Date
    09-26-2011
    Location
    Lansing, MI
    MS-Off Ver
    Excel 2003
    Posts
    4

    Conditional format for overdue date

    Hello,

    I have tried to firgure this out by reading other threads but cannot seem to find a formula to apply to my spreadsheet. Long story short, I am trying to create a spreadsheet to determine if a medical or dental appointment for a child is over due. Essential I would like the overdue date to be highlighted in red.

    So for example, I have the "last medical date" in column "I". Each child is supposed to have a medical every year. In column "L" I have put a formula that inputs the date exactly a year from the "last medical date". I need for the date in column "L" to be highlighted if it is past a year from the date in column "I". I guess it would be helpful too, if I can create another condition that changes the color for dates at 9 months??????

    Oh, I am using Excel 2010....

    Please help!
    Last edited by monstur1; 09-30-2011 at 12:14 PM. Reason: additional info.

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