Conditional Formatting for Training Expiration Dates

[jeff.kennedy]

Good Afternoon,

I manage a number if individuals in the Army and as such, track their annual training requirements. Some requirements are semi-annual, annual, quadrennial, etc...

I have a spreadsheet to track the dates that the requirement was last completed (attached). I would like to use conditional formatting to turn dates that are within 30 days of being due (or blank) RED and dates that are between 31 days and 60 days of being due YELLOW.

I am using Excel MAC 2011. I'm computer savvy but excel formula dumb! Any help, along with a quick tutorial would be greatly appreciated.

Jeff

[Richard Buttrey]

Hi,

See attached.

I've added conditional formats for annual and semi-annual columns.

[jeff.kennedy]

Richard,

I appreciate it, but it's not working the way that I intended. The blanks need to be red and there are multiple dates that are over a year old that did not turn red.

Thanks,

Jeff

[Leathermyth]

How about this?

Do note; I used 3 different colors of red just to differentiate between your parameters. You can go into Manage Rules and change them to whatever you like.