due date formula

[mikey]

i need to know how to add a formula that will turn a cell red when i enter a
date after the due date (entered in another cell) ..... any ideas??

 

[eksh]

let say $A$1 is the due date.
you go Format>Conditional Formating, using "cell value is" less than =$A$1,
choose Format cell color to red.

 

[eksh]

let say $A$1 is the due date.
you go Format>Conditional Formating, using "cell value is" less than =$A$1,
choose Format cell color to red.