Format Cells within a table

[dpal]

How do you format a cell that has a "0" in it within a table so it won't
print? Can't use filter to elliminate it there are other things in rows or
columns I need.
With out the table I can change font color to white or set conditional
format but I can't see to do that when I have a colored table.
Can you help?

 

[Jacob Skaria]

If the table values are generated from formula use a IF condition to handle
all zeros. If all values are more than 0 with no decimals then custom format
that to FormatCells>CustomFormat>Type:=
#;""

 

[Jacob Skaria]

If you have decimals
#,##0.00;-#,##0.00;
OR
#,##0;-#,##0;


Another way is to goto Tools>Options view, Uncheck zero values...but will
take off zeroes for the entire workbook not just for the table

If this post helps click Yes