due date formula

M

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

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.
 
Top