Here is the problem. I have members (over 900) in my spreadsheet that have
taken annual classes on different dates throughout the year Each class is due
within 365 days.

I am looking for a formula that will highlight when the class is coming due
for the next year.

(example: John took a class on 25 January 08. His next class is due 25 Jan
09. 30 days out, 26 Dec 08, his name should show yellow and on 26 Jan 09 he
will be overdue and should show red.)

I understand conditional formatting but I can't figure out the formula so I
can set the conditions.

Anyone have any ideas?

Dolphin wrote:
Here is the problem. I have members (over 900) in my spreadsheet that have
taken annual classes on different dates throughout the year Each class is due
within 365 days.

I am looking for a formula that will highlight when the class is coming due
for the next year.

(example: John took a class on 25 January 08. His next class is due 25 Jan
09. 30 days out, 26 Dec 08, his name should show yellow and on 26 Jan 09 he
will be overdue and should show red.)

I understand conditional formatting but I can't figure out the formula so I
can set the conditions.

Anyone have any ideas?


If your class date is in A1, use the following for conditional formatting:

=TODAY()-A1335