Conditional Format Entire Row Based On One Cell In Row

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

Assuming your 5 columns are A to E and you want to highlight them all for specific rows where zip code is 12345.

Select columns A:E

Use conditional formatting with "formula is" option and the formula

=$E1=12345

Select required formatting

Note: the $ sign is essential

Daddylonglegs, thank you for the quick answer. Your method works great, although the $E1 doesnt' make complete sense to me. I thought I would have had to put a range in there.

If you don't mind I would like to take this a step further. My first column is a unique "ID Number". I already have a conditional format rule set up to find duplicate values in that column and apply a format with cell color, strike-through, etc. to make it immediately obvious if I try to create a new row that has the same "ID Number" as a previous row. Is there an easy way to have this conditional format applied to the entire row instead of just the cell in the column being checked for duplicate values?

Thanks, Spence

Still selecting the 5 columns you can use

=COUNTIF($A:$A,$A1)>1

If you want both conditions to apply in the same row then you'll need to use 3 conditions

condition 1
=($E1=12345)*(COUNTIF($A:$A,$A1)>1)

condition 2
=COUNTIF($A:$A,$A1)>1

condition 3
=$E1=12345

Note: referring to just $E1 works because the formula automatically adjusts for each cell, in row 1 all 5 columns remain =$E1=12345 [ because the $ prevents any change] but in row 2 this will become $E2=12345

Dear daddylonglegs, thank you for very helpful answers. Could you please add another example of using "Conditional Format Entire Row Based On One Cell In Row" when the criteria is that Cell contains a "string"

Thanks a lot in advance.