Closed Thread
Results 1 to 2 of 2

Excel 2007 : Help writing a formula

  1. #1
    Registered User
    Join Date
    03-02-2010
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    9

    Help writing a formula

    I have used conditional formatting to control most of my document, which is a list of dates that change color depending on how close it is to the date referenced in any cell. I have done well so far, but now i need to write my own formula to tell the page to turn cells blue that are more than 2 months old. Example: Today is 3/2 so all cells with January dates of this year would be blue.

    Two months old = blue...?
    last month = red
    this month = yellow
    next month = green.

    Any ideas?

    Thanks

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Help writing a formula

    Hi, and welcome to the forum. Please take a moment to read the rules and then edit your title in accordance with rule #1. Thanks.

Closed 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