|
conditional formatting using dates
How do I use conditional formatting using dates over 1 year old
|
conditional formatting using dates
To highlight dates 1 year old (to the day) or older use this formula with conditional formatting "formula is" option. =DATEDIF(A1,TODAY(),"y") If you have blank cells in your range you might also wish to adapt that to prevent blanks being highlighted so use =(A1<"")*DATEDIF(A1,TODAY(),"y") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=569234 |
| All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com