Using Conditional Formatting: Wanting to Highlight entire row based off of cell in column

My workbook is attached.

Under the 'Current Contractors (Melvindale)' sheet, I am looking at column F. I have conditional formatting to highlight the cell in yellow if it is 4 days before the due date, and Red if it is the day of the due date or past the due date. It is currently only selecting the cell in the F column, but I want it to select the entire row that that cell belongs to. I have never used conditional formatting, and the current formula that I am using, I retrieved from this website: http://www.techonthenet.com/excel/qu...rmat4_2010.php

Please Help

Select your range (i.e. A2:H25
New rule, use formula

for yellow
=AND(ISNUMBER($F2),$F2-4<=TODAY())
repeat for red
=AND(ISNUMBER($F2),$F2<=TODAY())
See attachment

You have your data set up as a Table so if you just select A2:H7 (the table data), it will expand as the table expands.

Your formulas have quotes around them. Just go into conditional formatting> manage rules and fix the ranges (A2:H7) and remove the quotes. It should work after that.