Results 1 to 5 of 5

Conditional Format based on Months.

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    30

    Conditional Format based on Months.

    Hi

    In Column D of my work book are a list of months, I'm trying to use conditional formatting to do the following:

    Highlight green the cells in Column D where the month is due (i.e the month is now).
    Highlight orange the cells that are one month passed the due month.
    Highlight red the cells that are two or more months passed the due month.

    I'm having trouble working out how to accomplish this - Can any one advise what would be best.

    I'm using Excel 2007.

    Thank you.
    Last edited by SpiritedAway; 02-20-2014 at 03:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Format - Dates greater than 18 months and 24 months
    By amandavan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-03-2024, 04:08 PM
  2. conditional format if date in field is within the next 6 months
    By Jason_C in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2017, 02:17 AM
  3. Replies: 2
    Last Post: 09-26-2012, 04:43 AM
  4. Replies: 0
    Last Post: 05-20-2011, 02:33 PM
  5. Conditional Format for Odd-Even Months
    By Excellant in forum Excel General
    Replies: 6
    Last Post: 02-26-2010, 05:35 PM

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