+ Reply to Thread
Results 1 to 6 of 6

conditional formatting to highlight what is late

  1. #1
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    174

    conditional formatting to highlight what is late

    hi guys,

    i have a bunch of dates in column C, and column D is empty (to be populated with dates eventually), i need it to go green if the date either on or before column C's dates, and red if it's passed (and no formatting if cell is blank!)

    can't for the life of me get it to work.
    Last edited by fabrecass; 01-22-2013 at 11:35 AM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: conditional formatting to highlight what is late

    You can use conditional formatting with two rules...

    =D2>C2 >> Red
    =D2<C2 >> Green
    HTH
    Regards, Jeff

  3. #3
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: conditional formatting to highlight what is late

    Hi Jeffrey,

    i have tried to be that simple minded honestly! it just doesn't work for some reason? seems to affect cells above the one i'm using and doesn't seem to be true to the adjacent cells.

    any idea what's going on?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: conditional formatting to highlight what is late

    One key to remember, whatever the first cell, ensure you highlight the range starting with the first cell.

    Example: First condition =D2>C2

    Make sure you hightlight the range with D2 and down

  5. #5
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    174

    Re: conditional formatting to highlight what is late

    i'm an idiot, i've figured it... thank you Jeff.

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,179

    Re: conditional formatting to highlight what is late

    You are very welcome and glad it worked out for you.

    Additional link...

    http://www.xldynamic.com/source/xld.CF.html#due
    Last edited by jeffreybrown; 01-22-2013 at 11:30 AM.

+ 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