当前位置: 动力学知识库 > 问答 > 编程问答 >

Conditional Formatting in Excel: Max value that is not zero

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: