I'm trying to design a training matrix with colour co-ordination.
For example:
Epilepsy Training
Expires: 3 years
So i've got:
=B6<=TODAY()-1095
and the cells turn red if date goes beyond 1095 days.
But what i also wanted to do was:
cells turn orange if theres only 1065 days left (1 month)
cells turn yellow if theres only 1005 days left (3 months)
But everytime i use the same formula as i did for the Red the new colour just supercedes that one.
Please can someone help?
Bookmarks