+ Reply to Thread
Results 1 to 4 of 4

Conditional format dates

  1. #1
    Registered User
    Join Date
    03-07-2011
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    5

    Conditional format dates

    I would like to enter a date into a cell, then in 5 days after that date the cell fill turns yellow, ten days red. Any help?

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Conditional format dates

    Welcome,

    Try Conditional Formatting.

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Registered User
    Join Date
    03-07-2011
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Conditional format dates

    I thought that was the answer. But I don't know what the dates will be between to make this work. I have ten people entering a date that they start a project (the dates all vary) but one thing remains true 5 days from the date they enter the project that cell needs to highlight to a yellow and 10 days from the date they enter it needs to turn red. (not that this needs to be clarified but I am a rookie excel user)
    Right now everyone is filling the cell on their own to demonstrate 5 days past 10 days past. This is dangerous because people will lie about the first date they put in so that nothing is ever highlighted red.
    thanks!!!
    Last edited by Mrs.Z; 03-07-2011 at 12:48 PM.

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Conditional format dates

    How about:
    Attached Images Attached Images

+ 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