| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up a formulas with an if date? | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| Date Formulas | Excel Discussion (Misc queries) | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
