conditional formatting to identify expiration dates in a training log

Julie M. , Good evening.

I used your example to implement the formulas to advise you about expiration of the trainings.
I am not sure if I understood your rules well.

What I did:
a) If the cell where lives the date of training is EMPTY:
ACTION: NOTHING IS DONE.

b) If the cell where lives the date of training HAS a DATE
AND
If the cell where lives the validation number of days is EMPTY:
ACTION: NOTHING IS DONE. (I suppose this training NEVER EXPIRES)

c) If the cell where lives the date of training HAS a DATE
AND
If the cell where lives the validation number of days HAS A VALUE
AND
Todays´s date is SMALLER than FINAL DATE minus 30
ACTION: Conditional Rule 1 (GREEN)
=AND(H3>0,H$1>0,TODAY()<(H3+H$1)-30)

d) If the cell where lives the date of training HAS a DATE
AND
If the cell where lives the validation number of days HAS A VALUE
AND
Todays´s date is GREATER than FINAL DATE minus 30
AND
Todays´s date is SMALLER than FINAL DATE
ACTION: Conditional Rule 2 (YELLOW)
=AND(H3>0,H$1>0,TODAY()>=(H3+H$1)-30,TODAY()<(H3+H$1))

e) If the cell where lives the date of training HAS a DATE
AND
If the cell where lives the validation number of days HAS A VALUE
AND
Todays´s date is EQUAL or GREATER than FINAL DATE
ACTION: Conditional Rule 3 (RED)
=AND(H3>0,H$1>0,TODAY()>=(H3+H$1))

I implemented these conditional formating rules on your cells.
They are implemented from H trough EH columns and till line 503

I hope it help you on your job.

Take a look at attachment.
Please, tell me if it worked for you.


Best regards from Brazil!

Marcilio,

Thank you so much for taking the time to show me the formulas needed for the spreadsheet. I'd looked at so many and didn't get any of them to work, but I'm very new at trying to utilize formulas.
I will certainly be looking into some classes to improve my Excel knowledge.

Yes, it works!

Your help is amazing, thank you so much!

Julie

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.