How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register.
Thanks.
MacOS – How to display zero value as blank cell in mac numbers 3.1
macmacosnumbers
Related Question
- How to create a running total in Apple Numbers (4.0ff)
- Any way to use a VLOOKUP formula in Numbers to insert an image instead of text value
- In Numbers can you auto-populate a cell with a date when another cell is populated
- MacOS – How to combine two text values from different cells to equal another cell
Best Answer
The easiest way is to use "Conditional Highlighting..." found under the "Format" menu.
Select the cell you want to have blank as zero then select "Conditional Highlighting" you then set a highlight when the cell is equal to zero. Choose "Custom Highlighting" at the bottom of the style list and then you can set the text colour to white. A "blank" cell on zero.