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]<>

 

[MWhiteDesigns]

Yep, should work

hmm..

 

[MOB]

PM sent

 

[VishMishra]

Hi,

use this below formula in the Formula:

=($M1< TODAY())*($M1<>"")

And put this in "Apply to" section:

=$D:$D