+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting Dates

  1. #1
    Forum Contributor
    Join Date
    09-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    132

    Arrow Conditional Formatting Dates

    Hi,

    I am looking to put some conditional formatting on dates however need some IF statements somewhere.

    Further explained in the example spreadsheet.

    Example3.xlsx

    Cheers

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: Conditional Formatting Dates

    Please confirm which column cell needs to be highlighted?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365
    Posts
    12,815

    Re: Conditional Formatting Dates

    Like this ?
    Attached Files Attached Files

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.67 - (22111300)
    Posts
    7,539

    Re: Conditional Formatting Dates

    use the following three conditions
    red
    =AND(P4="",TODAY()+21>J4)
    amber
    =AND(P4="",TODAY()+42>J4)
    green
    =AND(P4="",TODAY()+42<J4)


    in that order and use stop if true

    see attached
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    09-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    132

    Re: Conditional Formatting Dates

    This is great. Thanks both

+ Reply to Thread

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