I have columns with zero or positive float values. My current format condition is:
Cell value is equal to
The idea of this conditional format is to format only cells that are not
$A$1) part is the current cell. It can be from
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.