+ Reply to Thread
Results 1 to 2 of 2

Conditional Formating for dates of renewing driver's licence

  1. #1
    Registered User
    Join Date
    04-26-2012
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Conditional Formating for dates of renewing driver's licence

    I need cells to change colors based on the date that the license will expire. I am using excel 2010.

    Example:

    I want the cell to turn red if the license has already expired.
    Yellow if the license will expire in 30 days or less,
    and green if it is 60 to 30 days until expiration.

    Note that the date of the expiration will be in the cell.

    My name should give you an idea where I am with this. Any help is greatly appreciated.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Conditional Formating for dates of renewing driver's licence

    Assuming your cell is A2
    Use these 3 rules:
    =AND(A2<>"",TODAY()>A2) red
    =AND(A2<>"",A2-TODAY()<=30) yellow
    =AND(A2<>"",A2-TODAY()<=60) green

    list the 3 rules in that order

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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