Help with conditional formatting

Hello, i have a spreadsheet at work that tracks job statuses and i would like to have it auto fill certain colors depending on how long the project has been open, amber for a few days, orange for a week and red for longer than a week and green for when it is complete, i am having trouble linking the "complete" column with the "days since received" , so when a cell in the days received column is populated, the corresponding cell is changed to green, part of the problem is a have a color changes set up to a basic cell value is between X and Y, but i want to override that if the complete cell on that row is filled, and i would rather not have to make a rule for every row on the sheet, 500 times is a bit much, thank you