5

I am trying to work through multiple if/and statements to use red/yellow/green/gray indicators without much luck.  Essentially, I would like the formula to produce the following:

If % Complete = 1, Green

If % Complete < 1, and finish date is within 7 days, Red

If % Complete < 1, and finish date is