+ Reply to Thread
Results 1 to 4 of 4

Due Date Conditional Formatting

  1. 04-01-2014, 05:36 AM #1
    JamesW254 is offline
    Registered User
    Join Date
    12-12-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    Due Date Conditional Formatting

    Hi all

    I am sorry if this has been covered before but I have searched past threads and have been unable to get this conditional formatting to work...

    In the attached workbook I need to conditionally format the Target Date (Resolution) to a traffic light Yellow,Amber,Red based on the current date. However if the status is Closed it should not be Red even though the due date has passed because the case has been resolved.

    I hope you understand what I mean.. I have been trying to do it myself now for an hour or so but haven't been getting very far.

    Thanks,

    James
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-01-2014, 05:58 AM #2
    JamesW254 is offline
    Registered User
    Join Date
    12-12-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Due Date Conditional Formatting

    anybody out there?
    Reply With QuoteRegister To Reply
  3. 04-01-2014, 09:52 AM #3
    JamesW254 is offline
    Registered User
    Join Date
    12-12-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Due Date Conditional Formatting

    Somebody help me! Please.
    Reply With QuoteRegister To Reply
  4. 04-01-2014, 10:07 AM #4
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Due Date Conditional Formatting

    Hello

    You don't say us the conditions for the 3 differents colors.

    For 1 condition try something like this.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Conditional formatting based on date - delete format if a date is entered in next cell
    By menstonbantam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2013, 06:21 AM
  2. [SOLVED] Conditional formatting: two different fields affect one cells formatting for a date.
    By gluktar in forum Excel General
    Replies: 2
    Last Post: 09-19-2013, 10:34 AM
  3. Conditional Formatting on another cells date value to the current cell date
    By jennys83 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 12:55 PM
  4. [SOLVED] Conditional Formatting: Highlight a cell containing a date after 1 year past that date!
    By Christopher1990 in forum Excel General
    Replies: 5
    Last Post: 08-22-2012, 05:06 PM
  5. [SOLVED] Conditional Formatting: Calculate Date One Year Later From Another Date
    By Kym2101 in forum Excel General
    Replies: 9
    Last Post: 05-01-2012, 09:52 PM

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