Conditional Format Entire Row Based On One Cell In Row

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.