Conditional Formatting for highlighting after today's date.

[Newbienew]

I am looking to highlight any dates that passed, however, when I use the built in format it highlights the blanks as well. When I used if($n6<=today(),"true","") it does the same thing. My goal is to just highlight any dates that are today's date and past, without the blanks being highlighted as well. Your help is greatly appreciated

 

[DanteAmor]

Try this formula

=AND($N6<>"",$N6<=TODAY())

Note: The formulas in the conditional format evaluate whether the condition is met, it is not necessary to put the result "True,False" within the formula.