I have a spreadsheet that shows due dates. I have formatted it so that those
who are more than a month overdue the date is in red, those who are overdue
by less than a month or will be overdue in a month are in yellow. The
remaining are in the clear have no color associated with them.

My boss would like the whole row colored, not just the cell with the due
date. How can I do this?