Hello all!

I've not frequented this forum in a while! Catching up on the various threads and all and remembered this not only a nice friendly little corner of the web but a GREAT place for excel help! So as I catch up...

I'm looking for a way to fill a cell (green/red) based on time passed from a certain date. Basically I'm working a project where a candidate is eligible for a position as long as they have 6 months experience from hire date. This is really simple and I could just do it manually but I'd like to create a temple file where anyone can just enter in the employee's basic info and the sheet auto-updates.

Any suggestions?

Thanks!