| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date passed formula
Hi all,
I need to create a formula which highlights a row when todays date excedes a date set in a cell, for example, the date in cell 'A1' is 07.06.10 and todays date is 08.06.10, therefore row A is highlighted in red. Any ideas? |
|
#2
|
|||
|
|||
Quote:
use this formula in conditonal formatting and set color to red =AND($A$1<TODAY())
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula that tells when a date is passed | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| how do I fix a forecast date that has passed for a zero value? | Excel Discussion (Misc queries) | |||
| IF Formula to calculate whether date has passed | Excel Discussion (Misc queries) | |||
| Date Passed Notification | Excel Discussion (Misc queries) | |||
Linear Mode
