The TOP 1 item in a row Conditional Format seems broken to me

[Mr_Phil]

Cells a:d in all rows contain numeric values. Cells D thru a lot are data points that explain those numbers.
I highlighted the four cells and selected the conditional format option to highlight the top 1 item in green.
That worked.
I copied that format down all the other rows (260 or so) and instead of highlight one of four cells per row it highlighted the one cell in the entire block that the format was pasted to.

Any idea what I did wrong?

 

[Asbestos_Jen]

I think for the "top" and "bottom" rules, each range needs to be added separately as a new rule Top picture). Filling down/format painting changes the range to an array (bottom picture).

 

[AhoyNC]

You need to use the NEW RULE option.
See attached link.

Excel: How to Highlight Max Value in Each Row - Statology

This tutorial explains how to highlight the max value in each row in Excel, including an example.

www.statology.org

 

[kevin9999]

You actually only need one rule.

Book1
	A	B	C	D	E
2
3	1	2	3	4
4	5	8	8	9
5	6	7	2	1
6	9	3	1	8
7
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:D6	Expression	=A3=MAX($A3:$D3)	text	YES

 

[Mr_Phil]

I think for the "top" and "bottom" rules, each range needs to be added separately as a new rule Top picture). Filling down/format painting changes the range to an array (bottom picture).

View attachment 103965

I was prepared to go there. I just really didn't want to. Thank you though. I appreciates your time that you took to help me out.

 

[Mr_Phil]

You need to use the NEW RULE option.
See attached link.

Excel: How to Highlight Max Value in Each Row - Statology

This tutorial explains how to highlight the max value in each row in Excel, including an example.

www.statology.org

You actually only need one rule.

Book1
	A	B	C	D	E
2
3	1	2	3	4
4	5	8	8	9
5	6	7	2	1
6	9	3	1	8
7
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:D6	Expression	=A3=MAX($A3:$D3)	text	YES

Guys you are great. Both of you came up with the same thing and the board only let me mark one as a solution. But I wanted to say that I am very grateful for the time you took to help me out. Thank you.