Conditional format help please

[kcleere]

In one cell where a date is entered I have 3 conditions.

If date is blank or equals today or greater I want nothing

If date entered is less than today I need the font to be red

If date entered is "within" "less than" 5 dates of today I "also" need the cell to highlight yellow.

I tried....thus...here I am.

Thank you as always.

 

[RSXchin]

Condition 1 = "" OR = Today()
Condition 2 LESS THAN = Today()
condition 3 should be BETWEEN = Today() and =Today() + 5