Results 1 to 13 of 13

Conditional Formatting between two dates that are not today!

Threaded View

  1. 01-10-2014, 05:50 PM #1
    IreneADS
    IreneADS is offline
    Registered User
    Join Date
    01-02-2014
    Location
    Canada
    MS-Off Ver
    Excel 2013
    Posts
    31

    Conditional Formatting between two dates that are not today!

    I know this is fairly easy but I just don't get it!

    I would like to change the colour of the date in the second column:
    to red if it is more that 7 days from the first column
    to green if it 7 days
    to blue if it is less than 7 days

    Column 1 | Column 2
    Sent To Print | PRINTED
    1-Jan-14 | 9-Jan-14
    Last edited by IreneADS; 01-15-2014 at 05:43 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting formula IF TODAY Between range of dates, color cell red
    By vayana in forum Excel General
    Replies: 5
    Last Post: 12-31-2013, 01:44 AM
  2. [SOLVED] Conditional Formatting: Change cells when dates shown are older than today
    By Kaykaneetit in forum Excel General
    Replies: 3
    Last Post: 11-20-2013, 08:42 AM
  3. [SOLVED] Conditional Formatting of: dates within 1 month and dates before today.
    By Luke Smith in forum Excel General
    Replies: 5
    Last Post: 06-18-2013, 07:29 AM
  4. Conditional format between dates based on today()
    By StevieNix in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-27-2012, 06:06 PM
  5. [SOLVED] Conditional Formatting ... Today() & More
    By Ken in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2005, 11:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1