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? |
Quote:
use this formula in conditonal formatting and set color to red =AND($A$1<TODAY()) |
All times are GMT +1. The time now is 02:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com