+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatinh

  1. 05-19-2007, 01:11 PM #1
    steveman
    steveman is offline
    Registered User
    Join Date
    05-19-2007
    Posts
    1

    Conditional Formatinh

    OK, hoping some out there can solve this one for me!

    I have got a excel file i use to keep track of my companies training records and currently I have set the conditional formating to have dates in GREEN when the employees training is valid and RED when it has expired.

    What I would like it to do is go AMBER (or somethhing similar) when it is 3 months from the date in the cell.

    Im sure this is dead easy to do, but i just cant figure the damn thing out!

    Hope someone out there can help on this.

    I thank you in advance

    Steve Man
    Reply With QuoteRegister To Reply
  2. 05-19-2007, 02:07 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    You need to use two conditions

    One is for the date in the cell to be less than now

    i.e. the condition is less than = NOW()

    with the pattern set to red.

    Then press the add button and add a new condition

    i.e. the condition is less than = NOW()-92

    with the pattern set to amber.

    92 = 3 month's worth of days.

    Excel gives precendence to the first condition when both are satisfied.
    Martin
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1