Results 1 to 6 of 6

Conditional Formatting for passing specified dates

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2009
    Location
    Guildford, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Conditional Formatting for passing specified dates

    I'm having trouble putting the correct conditional formatting on a column of dates. Any help would be greatly appreciated!!

    Basically, in column 'A' I have a list of appointment dates. Column 'B' contains breach dates for a 10week target. And Column 'C' contains breach dates for an 18 week target. Looking something like this:

    Appointment ---10wk breach--- 18wk breach
    11/06/2009 ---16/02/2009--- 13/04/2009
    01/06/2009 ---21/05/2009--- 16/07/2009
    09/06/2009 ---05/02/2009--- 02/04/2009
    03/06/2009 ---11/05/2009--- 06/07/2009

    I need to format column 'A' so that the cells will turn Amber if the appointment was after the 10 wk breach date and turn Red if it was after the 18 wk breach date. I hope that makes sense!

    I know I need to use the conditional formatting function, but am not sure of the formulas etc I need to put in!

    If someone could help me out that would be fantastic!!
    Last edited by NBVC; 08-24-2009 at 10:12 AM.

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