View Full Version : Expired Dates
thdan74
Dec 22, 2006, 09:37 AM
I have a training spreadsheet in excel. I would like to know how to highlight a date if the dates has expired one year from today's date. Is there a way to do that?
cajalat
Dec 22, 2006, 09:41 AM
You can use "Conditional Formatting" to highlight the cell based on a given condition. Conditional Formatting is found under the Format menu.
ScottGem
Dec 22, 2006, 09:47 AM
The Condtion you would want would be something like:
Today() > A1+365
FirstKnight
Jan 30, 2007, 12:01 PM
Also make sure that the Condition 1 box says "Formula is" and you will need a "=" before the formula begins, so excel does not treat your formula as a string!