I have cells that display the sums from other worksheets. As it stand
right now if there is no value in the other worksheet the a 0
appearers in the totals cell. What I would like to do if possible is
instead of there being a 0 in the totals cell I would like it just to
be blank.

I have set up conditional formatting on the total cells to change the
font color if the value is greater than 0 but cannot seem to get rid
of the zero if there is no value to display.

Thanks,

Ty