I am applying a simple conditional format to column of values that formatted as currency. I am trying any cells that are "$0.00".
I have the conditional format for a "Highlight Cell, Equal To"and the value to equal is 0.
This cause any blank cells to become conditionally formatted as well. Is there way to not condition blank cells when looking for a zero value?