I'd like to conditionally format cells that will go red if it's past its expiration, go yellow if it's within 3 months of expiring, to remain green if date is clear of expiry.
today's date is the 15/10/15
- Cell has written in 26/09/19 (this should be green)
- Another cell has 10/11/15 entered - so within the 3 months (this should now be yellow)
- Another cell has 13/10/15 entered - now expired (this should now be red)
Is it possible to do it this way?