[SOLVED] Date formulas

[Cachod1]

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]

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" <[email protected]> wrote in message news:[email protected]...
> 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?
>