Conditional Formating-How can I set conditional formating to highlight

How can I set conditional formating to highlight a date a specified number of
days older than today's date (e.g. a training date more than 2 years old)?
I've done this using two columns but would like to use only the column
containing the actual training date.

With dates in col. A and the # of days to use in F1,
select col. A, go to Format > Conditional Formatting,
choose "Formula Is" and put:

=$A1<TODAY()-$F$1

Click the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>How can I set conditional formating to highlight a date
a specified number of
>days older than today's date (e.g. a training date more
than 2 years old)?
>I've done this using two columns but would like to use
only the column
>containing the actual training date.
>.
>