Here is a formula (well, an idea of a formula) that I was thinking about... If I could just get some assistance with making it work on Excel with the correct arguments that would be helpful.
IF(330-days>D:D>365-days,color=red,IF(300-days>D:D>329-days,color=yellow,'no color change'))
Now, if someone could just help me turn that garbage above into an actual formula.
So what the 'formula' above is saying is:
If column D is within 330-365 days, the color should be red, if not then next step: If column D is within 300-329 days, the color should be yellow, if not then next step... If neither criteria is met, then there should be no color change...
Bookmarks