Hide text in shaded cell
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.
|