Conditional Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional formatting based on a different cell 2
Conditional Formatting with dates 3
conditional formatting date and blank cell 3
Conditional Formatting Applied when Statement Not True 6
Percentage of Cells completed 3
Pivot Table/Conditional Formatting Guru Help 2
[Flashing] RED before renewal date 1
Date Calculation & Conditional Formatting 3

Back
Top