I have a spreadsheet of various currency values. I want zero values to be formatted in red. Negative values are currently in red, but I can’t figure out how to extend that to zero. I looked into conditional formatting and creating styles, and I’m just not understanding how I can accomplish this.
Create a third section in the ‘Numbers’ format code, and apply there the same formatting as in the second section, but without the minus sign (if any). The new code section will start with [RED] then.
Thank you. This gives me what I want. I did have to go back and clear a bunch of formatting things that were added somehow but once I found and deleted those additions it looks good.