I have not worked with conditional formatting much at all. I have been able to apply conditional formatting to a column of data, but I would like to highlight the entire row instead of just the one cell in that column.

Say I have five columns of data for each record (ID Number, Address, City, State, ZIP Code). I know how to apply conditional formatting based on the zip code and have Excel highlight the cells in the zip code column that meet my conditions. What I would like to do is have it highlight not just the zip code, but also the ID number, address, city, and state when a zip code meets a condition.

Thanks, Spence