Page 1 of 2 12 LastLast
Results 1 to 10 of 13

highlight cell if date is prior to todays date

This is a discussion on highlight cell if date is prior to todays date within the Excel Questions forums, part of the Question Forums category; I want to highlight a cell if the date is before todays date. Cell M3 contains a due date, when ...

  1. #1
    Board Regular
    Join Date
    Nov 2010
    Posts
    525

    Default highlight cell if date is prior to todays date

    I want to highlight a cell if the date is before todays date.

    Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but it highlights the whole column. I'd like it to leave everything untouched until the date is passed.
    Code:
     
     
    =$M$3 < TODAY()
    Last edited by MWhiteDesigns; Jan 27th, 2012 at 11:23 AM.

  2. #2
    MOB
    MOB is offline
    Board Regular
    Join Date
    Oct 2005
    Location
    Northants, UK
    Posts
    808

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MWhiteDesigns View Post
    I want to highlight a cell if the date is before todays date.

    Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but nothing happens. What am i doing wrong?

    Code:
     
    =$M$3>TODAY()
    I think you want a < instead of a >

    ?

  3. #3
    Board Regular
    Join Date
    Nov 2010
    Posts
    525

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MOB View Post
    I think you want a < instead of a >

    ?
    I caught that, and edited the Original post. Please see above

  4. #4
    MOB
    MOB is offline
    Board Regular
    Join Date
    Oct 2005
    Location
    Northants, UK
    Posts
    808

    Default Re: highlight cell if date is prior to todays date

    If it highlights the whole column, the cond formatting must be set to do that?

    If you click on manage rules, what does it say under "applies to"?

  5. #5
    Board Regular
    Join Date
    Nov 2010
    Posts
    525

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MOB View Post
    If it highlights the whole column, the cond formatting must be set to do that?

    If you click on manage rules, what does it say under "applies to"?
    Hm, so i tried a new fomula.

    Id like to have the cell M3 (due date) , highlighted in red if it passes todays date. In addition if there is a date in N3( completion date) it does not highlight anything.

    i thought this might do it. its not working either.

    Code:
     
     
    =AND(TODAY()>M3,N3="")

  6. #6
    MOB
    MOB is offline
    Board Regular
    Join Date
    Oct 2005
    Location
    Northants, UK
    Posts
    808

    Default Re: highlight cell if date is prior to todays date

    Got your <>'s mixed up again?

    Edit - maybe not.....................

  7. #7
    MOB
    MOB is offline
    Board Regular
    Join Date
    Oct 2005
    Location
    Northants, UK
    Posts
    808

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MWhiteDesigns View Post

    Code:
     =AND(TODAY()>M3,N3="")
    That works for me

  8. #8
    Board Regular
    Join Date
    Nov 2010
    Posts
    525

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MOB View Post
    Got your <>'s mixed up again?

    Edit - maybe not.....................
    I didn't think i did this time,

    as i thought it read,

    if Todays date is greater than the value in m2, and n2 is blank...format accordingly (red) ?

  9. #9
    Board Regular
    Join Date
    Nov 2010
    Posts
    525

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MOB View Post
    That works for me
    Hm, I wonder why its not doing anything for me.

    All the cells stay white until dates are entered ?

  10. #10
    MOB
    MOB is offline
    Board Regular
    Join Date
    Oct 2005
    Location
    Northants, UK
    Posts
    808

    Default Re: highlight cell if date is prior to todays date

    Quote Originally Posted by MWhiteDesigns View Post
    I didn't think i did this time,

    as i thought it read,

    if Todays date is greater than the value in m2, and n2 is blank...format accordingly (red) ?
    Yep, should work

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com