How do I write the Conditional Formatting formula so it will ignore 0 values?

[arthurz11]

 

[Eric W]

Try:

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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E6	Expression	=AND(A2=MAX($A2:$E2),A2>0)	text	NO

 

[arthurz11]

Try:

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

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E6	Expression	=AND(A2=MAX($A2:$E2),A2>0)	text	NO

Works perfect!!! Thank you soooooo much!

 

[Eric W]

Happy to help!