Conditional Format: highlight max value in row where all cells are equal

[Tashat]

Hi again

I'm having some trouble with conditional formatting. I have set up conditional formatting so that the highest value in each row is highlighted purple. However, I have two rows where all the values are the same (all zero) and in this instance, I don't want any cells to be highlighted, but instead the whole row is highlighted. Can anyone advise me on how to prevent the cells highlighting in these instances? As always - thank you in advance.

Operations_MI_Als_team.xlsx
	O	P	Q	R	S	T	U	V
8	220	210	230	172	262	245	233	200
9	253	252	263	197	342	294	271	237
10	303	296	311	247	384	351	321	293
11	99	84	92	92	102	112	99	98
12	0	0	0	0	0	0	0	0
13	0	0	0	0	0	0	0	0
14	479	468	490	415	573	553	503	465
15	629	615	638	582	795	759	689	663
16	836	787	803	728	1068	974	869	840
17	891	843	860	797	1171	1054	948	914
18	975	911	963	905	1340	1201	1038	1012
19	975	911	963	905	1340	1201	1038	1012
20	975	911	963	905	1340	1201	1038	1012
All data - CEM (19Oct>31Dec)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O8:V1048576	Expression	=ISBLANK(O8)=TRUE	text	YES
O8:V1048576	Expression	=O8=MAX($O8:$V8)	text	NO

 

[Fluff]

What should happen if the max values occurs in 2 cells?

 

[Tashat]

If the max value were to happen in two cells, I would want that to be highlighted (which I appreciate from a logic perspective contradicts what I've just said above) - I think it's probably where the whole row equals 0.

 

[Fluff]

Ok, this will ignore any blank cells & cells that are <=0

+Fluff v2.xlsm
	O	P	Q	R	S	T	U	V
8	220	210	230	172	262	245	233	200
9	253	252	263	197	342	294	271	237
10	303	296	311	247	384	351	321	293
11	99	84	92	92	102	112	99	98
12	0	0	0	0	0	0	0	0
13	0	0	0	0	0	0	0	0
14	479	468	490	415	573	553	503	465
15	629	615	638	582	795	759	689	663
16	836	787	803	728	1068	974	869	840
17	891	843	860	797	1171	1054	948	914
18	975	911	963	905	1340	1201	1038	1012
19	975	911	963	905	1340	1201	1038	1012
20	975	911	963	905	1340	1201	1038	1012
21
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O8:V21	Expression	=AND(O8>0,O8=MAX($O8:$V8))	text	NO