问题描述:

I have columns with zero or positive float values. My current format condition is:

Cell value is equal to =AND(MAX($A$1:$A$50),A1<>0)

The idea of this conditional format is to format only cells that are not

The A1 (not $A$1) part is the current cell. It can be from A1 to A50. They are currently no format when all of them are zeroes. But when I modified one of the cell to any positive value, let say 0.01, the formatting does not take effect.

What is the correct condition for this case?

网友答案:

this worked for me: =AND(MAX($A$1:$A$50)=A1,A1<>0) The range was A1:A50. It highlighted the maximum value only.

相关阅读:
Top