Conditional Formatting for entire row based on ranges of number in column F

Hi,

Hope someone can help me here....

I've attached a small excel file where I need some conditional formatting to work, but I'm stumped. Pretty sure I would have to use the "Use formula to determine which cells to format", but don't know which formula to use.

I need rows to be specific colors (shown in the attachment) as related to certain numbers.

So, in column F - Days Until Due/Overdue, if the negative numbers (2) through (6) appear (these cells reference the Due Date column D2 using the Networkdays formula) then I want all of those cell rows to be yellow, text is red. For negative numbers (7) through (11), I want the cell rows to be orange, for negative numbers (12) through (16) to be orange, accent 6, darker 25%, text to be black for visibility and for numbers that are (17) AND ABOVE, then those rows would all be red, text to be black for visibility. These items would be all OVERDUE.

For the number 1 generated, then that row should be green.

For positive numbers greater than 1, then those are all gray, Days Until Due.

I'm showing these numbers in a numerical order for explanation purposes only, that's not really how they show up based on Due Date when I run the report.

These numbers will change on a daily basis when someone opens the file, again based on the Networkdays formula, so I would expect the colors to change accordingly, that's why I figured conditional formatting would work.