Format Cells within a table
 

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?

Format Cells within a table
 

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 FormatCellsCustomFormatType:=
#;""

--
If this post helps click Yes
---------------
Jacob Skaria


"dpal" wrote:

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?

Format Cells within a table
 

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


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

If this post helps click Yes
---------------
Jacob Skaria


"dpal" wrote:

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?