Alana has attended:
Excel Intermediate course
Cell Format wihich highlights a date longer than a year
can someone help me, i have a spreadsheet where i input dates for each person and i want it to highlight if the date is over a year old?
RE: Cell Format wihich highlights a date longer than a year
Hi Alana
You would need to use the 'Use a formula to determine..' option.
The formula needs to equate to TRUE for the conditional format to be applied.
Something like =(TODAY()-B3)>365
B3 is the cell containing the date you want to check.
Regards
Dennis