+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional Formatting_change cell color for dates

  1. #1
    Registered User
    Join Date
    11-22-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Conditional Formatting_change cell color for dates

    I need help with conditional formatting in Excell 2007. I have the Expected Date in column B and the Actual Date in Column C. I need to create the below functions:

    1. If Actual Date is blank and Expected Date is today or later: Actual Date cell is RED.
    2. If Actual Date is blank and Expected Date is 1-14 days before today: Actual Date cell is YELLOW.
    3. If Actual Date cell has a date, but it is later than Expected Date: Actual Date cell is ORANGE
    4. If Actual Date cell has a date and it is on or before Expected Date: Actual Date cell is GREEN.

    Any assistance would be greatly appreciated.

    TinaS

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Conditional Formatting_change cell color for dates

    Quote Originally Posted by TinaS
    I need help with conditional formatting in Excell 2007
    Please modify your profile in line with the above (presently states 2003) - you would not be able to do the above prior to 2007 given there are only 3 conditional formats plus standard available.

    With C1:Cn selected try applying Formula based rules of:

    Please Login or Register  to view this content.
    Modify references to row 1 as necessary of course.

    If in doubt - post a sample file.

  3. #3
    Registered User
    Join Date
    11-22-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional Formatting_change cell color for dates

    Great! thank you for the quick reply.

    Tina

+ 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