Prevent the display of a cell value

[RLY]

Can I use code to prevent values in a row of cells from displaying? I do not want to physically hide the row or cells, I just want them to "appear" blank or clear (as if I used white font on a white background).

Thanks, Robert

 

[prabby25101981]

Is there a certain condition basis which you want to do that?

 

[BillP]

You could use Conditional Formatting to do that (say, hide all instances of 0 by coloring it to match the background). To hide all numbers or a range of numbers, just make the conditional formatting cover the whole range.

One caveat: If someone highlights the cells (say, with a mouse), the data will show up--dim, but perfectly clear. Two caveat: If someone prints the spreadsheet with print settings set to Black and White, those numbers will print out the same as any other number (Page Setup, Sheet tab, Black and white).

 

[pgc01]

Hi Robert

Use a custom format to display nothing:

;;;

 

[RLY]

There are certain rows containing numeric values (calc results) that I want to hide 100% of the time (can't get rid of them because they're needed for other calcs). I was hoping for something other than conditional formatting to prevent the row from being highlighted & viewed...
How do I set a "custom format"?

thx, Robert

 

[pgc01]

How do I set a "custom format"?

- Select the cells
- Right-Click, select "Format Cells ..."
- in the Number tab select "Custom"
- in the "Type" textbox enter your custom format, in this case:

;;;

 

[pgc01]

P. S.

If your purpose is not aesthetic and you want to prevent the user to see the values in the cells, a formatting solution will not do, as you can still select the cell and read the value in the formula bar.