ExcelBanter - Date formulas

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Date formulas (https://www.excelbanter.com/new-users-excel/19512-date-formulas.html)

Cachod1

Date formulas

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" 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?

All times are GMT +1. The time now is 10:41 AM.