You can use CF

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

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Cachod1" wrote in message ...
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?