+ Reply to Thread
Results 1 to 2 of 2

conditional format based on date

  1. #1
    Forum Contributor
    Join Date
    09-24-2009
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    129

    conditional format based on date

    cell C3 has a date of Mar 5, 2013. I want that cell to be green until after 90days. after 90 days I just want no fill.

    so on until june 3, 2013 that cell should be green.

    any ideas?

  2. #2
    Registered User
    Join Date
    11-16-2012
    Location
    Rhode Island, USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: conditional format based on date

    I have a similar setup on one of my spreadsheets.

    Format cells that contain "Cell Value", "greater than", "=TODAY()-90". Set your format.

    To test: 90 days ago from today was 12/5/12. This should appear with no fill. 89 days from today, 12/6/12, should appear in green.

    I hope that helps!

    E

+ 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