If this cell=0, "",if not, this cell plus 45
"Elaine" wrote in message
...


I have a problem of this kind too. I have a grey box with a formula (if
this
cell = 0, 0, if not, this cell plus 45). When it shws 0, i don<t want the
zero to be seen and when it is not 0, i want to see it.

With an older version of office, i used contitionnal formatting and put
the
font of the text the same color of the box when i didn't want 0 to be seen
but now, with that so helpful new version of office, when i print, i can
see
that 0. I's kind of ugly cause now my document is full of 0 while before
we
couldn't see it. Since i show the document to my customers, i need a
cleaner
document.

The ;;; won't help me in my case because i would have to change my whole
document just because i changed one thing in my sheet. I want conditionnal
formatting to come back like the other Excel version.