Date formulas

Cachod1 · Mar 28, 2005

Cell A1 = due date. Need cell B1 to highlight in color if due date is <
today's date. What formula can I use to do this?

Ron de Bruin · Mar 28, 2005

You can use CF

See
http://www.contextures.com/xlCondFormat01.html

Select B1
Use this formula in CF
=A1<today()