How can i program a date field to turn red when the date is due

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field call Recon Due. Every month i need to be checkin which
recons are due for the month. But i would like the field to turn a different
color 2 weeks before is due. For example if i have one due on 7/25/2005 i
would like for that field to turn Blue and when it's past due i would like it
to turn red
 
Set the Conditional Formating for the field. All of the info is in help
if you need it. (Right click on the field and select Conditional Formating)
 
Back
Top