highlight cell if date is prior to todays date

[MWhiteDesigns]

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.

=$M$3<TODAY()< p> < TODAY()

<TODAY()[ p CODE]<>

 

[MOB]

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?

=$M$3>TODAY()

I think you want a < instead of a >

?

 

[MWhiteDesigns]

I think you want a < instead of a >

?

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

 

[MOB]

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"?

 

[MWhiteDesigns]

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.

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

 

[MOB]

Got your <>'s mixed up again?

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

 

[MOB]

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

That works for me

 

[MWhiteDesigns]

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) ?

 

[MWhiteDesigns]

That works for me

Hm, I wonder why its not doing anything for me.

All the cells stay white until dates are entered ?

 

[MOB]

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