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 |