Conditional formatting an entire row based on a specified cells value

[Helloitsme]

I've conditionally formatted the table correctly with coloumn E, but I can't seem to figure out how to make the conditional formatting count for the whole row, not just format coloumn E.

Kollektion.xlsx
	E	F	G
18325	SP-13707	8018365270756	Gianni Versace
18326	SP-13708	8011003996766	Gianni Versace
18327	SP-13723	8018365071261	Gianni Versace
Stock Perfume

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:R70000	Expression	=COUNTIF(Overview!$AA$6:$AA$70000;E5)	text	NO

 

[Joe4]

Lock down your column reference, like this:

=COUNTIF(Overview!$AA$6:$AA$70000;$E5)

 

[Helloitsme]

Lock down your column reference, like this:

=COUNTIF(Overview!$AA$6:$AA$70000;$E5)

Thanks again Joe, you're a true lad. Have been stuck on this for hours and now it works like a charm!

 

[Joe4]

You are welcome.

This absolute/relative range references keep popping up for you today!
Here is a good article to learn more about them: Excel Formulas: Relative and Absolute Cell References