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

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

"mikey" wrote:

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