due date formula

  • Thread starter Thread starter mikey
  • Start date Start date
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??
 
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.
 
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.
 
Back
Top