You're welcome. You can apply it to one cell and then use the Format
Painter to apply it to other cells, if they are not contiguous.

Thanks for feeding back.

Pete

On May 3, 12:46 pm, Louise wrote:
that would be a much quicker way, rather than using an IF on every formula.

Thanks for the help - again!

Louise



"Pete_UK" wrote:
Hi Louise,

one way is to apply conditional formatting to the cells with the
formulae in, such that if the cell contents are zero then choose the
foreground colour to match the background colour (usually white) - a
zero cell will thus appear to be blank.

Hope this helps.

Pete

On May 3, 10:52 am, Louise wrote:
Hi all

I have formulas on my worksheet and several of the 'answers' are zero, which
is correct, however, I want to format the whole worksheet so rather than
displaying '0', it simply leaves the cell blank.

How would I do this?

Thanks.
Louise- Hide quoted text -

- Show quoted text -