I have tried numerous ways to make the below work but I cant figure it out.
All of the cells change to the color, instead of just one.

I have a due date in Column E (manually entered) and need the following:
From 7 days before the due date up to the actual due date, the cell needs to
be Yellow. Anything from the due date forward, needs to be red.