Conditional Formatting in Excel: Max value that is not zero
<p>I have columns with zero or positive float values. My current format condition is:</p>

<p><kbd>Cell value is</kbd> <kbd>equal to</kbd> <code>=AND(MAX($A$1:$A$50),A1&lt;&gt;0)</code></p>

<p>The idea of this conditional format is to format only cells that are not </p>

<p>The <code>A1</code> (not <code>$A$1</code>) part is the current cell. It can be from <code>A1</code> to <code>A50</code>. 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 <code>0.01</code>, the formatting does not take effect.</p>

<p>What is the correct condition for this case?</p>