Results 1 to 4 of 4

Conditional Formatting or formula for comparing dates

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    4

    Conditional Formatting or formula for comparing dates

    I am looking for the best way to do this. I have a spreadsheet where a date something is received is entered in column A and the date it goes back out is in column G. I need to have the cell in G turn green if the date entered is within 7 days of the date in column A and turn red if it is 8 days or later. (hope that all makes sense)

    I have tried browsing through multiple thread and can't seem to get it right. Can anyone please help?
    Last edited by sweetds; 01-23-2013 at 11:02 AM. Reason: Question has been answered

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