I need to make a table where i just need to plot in "Date borrowed", and "Checkup" will ap

[Johanlindgren]

Hello!

I have an issue regarding dates on excel.
I am making a table of borrowed equipment, which needs to be accounted for once a year.
For example:

Name Discription Date borrowed Checkup
Paul Mobile phone 20.12.2013 20.12.2014

Every item that's borrowed needs to be accounted for when a year has passed. So I need "checkup" to be +1 year of "date borrowed"

I need to make a table where i just need to plot in "Date borrowed", and "Checkup" will appear automatically.
If "Checkup" has passed 1 year, i need it to be marked RED.
If "Checkup" has not yet passed 1 year, i need it to be marked GREEN.
This way it will be easy to keep track of which items that needs to be checked, and the items that does not.

if any of you could spend 5 minutes helping me with a reply, i would appreciate it greatly. I just got hired and kinda need some help with this.

[Glenn Kennedy]

Hi. Try this. One formula plus 2 conditional formatting rules.

[Johanlindgren]

You sir, made my day alot easier!
Thank you!

[Johanlindgren]

However, i cant seem to make them green, nor red if true/nottrue on my computer "/
How did u do that?
Thanks again!

[Glenn Kennedy]

Go back to my post. Click on B2.

Home/Conditional Formatting/Manage rules.

Copy/adapt to your real sheet.