+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting: if date is before today highlight only IF adjacent cell is blank

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Nottingham
    MS-Off Ver
    Excel 2003
    Posts
    57

    Conditional formatting: if date is before today highlight only IF adjacent cell is blank

    Hiya,

    I'm using Excel 2003

    What I have is two columns which contain dates:

    Date to be returned (D), and date returned (E).

    What I would like is if column D is before today's date, I want that to change colour, only IF the cell next to it in column E is blank. I also need this to be the case for future entries as it is continuously being added to.

    I can not attach the example for some reason so I hope this is enough.

    Can anyone help?

    Many thanks

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,732

    Re: Conditional formatting: if date is before today highlight only IF adjacent cell is bla

    Select col D and use the following CF
    Please Login or Register  to view this content.
    and format as needed

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    Nottingham
    MS-Off Ver
    Excel 2003
    Posts
    57

    Re: Conditional formatting: if date is before today highlight only IF adjacent cell is bla

    Thank you but it didn't work, I got the following result

    Expected Return Date returned
    30/08/2012 22/08/2012
    06/04/2013 06/06/2012
    06/07/2012 09/07/2012
    29/06/2012 26/06/2012
    15/04/2013
    18/07/2012
    18/06/2012 18/06/2012
    27/06/2012 09/07/2012
    12/06/2012 15/11/2012
    31/05/2013
    03/05/2012 03/05/2012
    02/07/2012 23/07/2012

    It highlighted a cell that was before today but the cell next to it isn't blank

    It ignored however the cell I hoped would be highlighted, the one cell which has a blank cell next to it but the date is before today.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,732

    Re: Conditional formatting: if date is before today highlight only IF adjacent cell is bla

    Works perfectly for me . I am unable to attach a file though

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,732

    Re: Conditional formatting: if date is before today highlight only IF adjacent cell is bla

    Seems to be working now. File attached cf Dates.xls

+ 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