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![]()
Bookmarks