Conditional Formatting question
Posted by Stu on May 14, 2001 5:29 AM
I have a column in my spreadsheet with expiration date of contracts. I would like to use the conditional formatting to highlight in red any contracts that will expire <= 12 months from today's date. What is the formula for this calculation?
Thanks,
Stu
Posted by Mark W. on May 14, 2001 6:18 AM
=$A2-DATE(YEAR(TODAY())+1,MONTH(TODAY()),DAY(TODAY()))<=0
