+ Reply to Thread
Results 1 to 3 of 3

Formula help

  1. #1
    Registered User
    Join Date
    03-11-2010
    Location
    St. Louis MO
    MS-Off Ver
    Excel 2003
    Posts
    1

    Formula help

    Ok.....I thought I had this figured out but its not doing anything!

    In a sheet I have a column for a date....Ex 12/1/09 -------- I would like to have the cell change color after it passes 75 days for the date thats in the cell....Example, 12/1/09 changes to yellow after todays date passes (for round numbers) 2/15/10............And then turn red after 90 days from 12/1/09-------------

    I used the formula as follows and I believe it should work but nothing happens. Please assume that A1 is the desired cell to change.

    Went to Format - Conditional formatting -
    1st condition.
    Formula (A1+90)<TODAY() changed the format to color the cell red

    2nd condition.
    Formula (A1+75)<TODAY() changed the format to color the cell yellow.


    Please help.....nothing happens......I checked TOOLS----OPTIONS----Calculations-----Auto.......Its ok so I think....

    Any ideas,,,,,,,,THANK YOU SO MUCH!

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Formula help

    You will be asked to change the title, so please change the title to reflect the subject matter instead of generic terms like formula, help etc. A descriptive title makes it easy for others to search for related topics.

    See the example attached. Use either one.

    modytrane
    Attached Files Attached Files

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula help

    Welcome to the forum, naterosy.

    Please take a few minutes to read the forum rules, and then amend your thread ttle accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

+ 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