Numbers Formula TO Show Blank Cell

Nancy Blazis wrote:

I would like to show blank cells (but still containing the balance)

A cell can be blank or it can contain a value. It can't be blank but still contain a value.

Not sure exactly what you are trying to do but you may find ideas you can use in this Checking Register Numbers document (Dropbox download).

It is based closely on a template that was included with an old version of Numbers.

SG

You want a cell to appear as blank even though it has a number (the running balance) in it? Below is one way to do it with conditional highlighting. The number will not be visible if it is equal to the one in the row above it. it is not necessarily a perfect solution but it should work for a checking register.

To make the rule:

1. Select the entire column E, other than headers and footers
2. Start to make a conditional highlighting rule
3. In the place where you see E1 in my rule, click on the green oval, click on the cell E1, edit it if necessary so it is E1 not E$1, then use the checkmark to accept it. This will make sense when you see it.
4. Choose "custom" for the highlighting and set the text color to white (or the same as the fill color). If you are using alternating row colors in your register, you'll instead have to set the text opacity to 0% (i.e., invisible) by clicking on the color wheel next to the text color box. You'll see the opacity slider in the little color wheel window that pops up. Slide the slider to 0%.
5. Click Done.