Conditional Formatting

[vwebb]

Hi,
I have a column of due dates then a column of submission dates.

I want to highlight entries (that have not been submitted based on the second column) with due dates in 14 days with yellow.

Highlight entries not submitted (based on second column) with red that are passed due based on todays date.

Thank you,

 

[oldbrewer]

something like select formula then and( =B1="",(A1-today())<14)