macropod,
Quote:
Originally Posted by macropod
Your point being?
|
Apparently lost with you.
Quote:
Originally Posted by macropod
Your advice:
is plain wrong. It will only hide 0s in the cells to which the custom format is applied - not all cells in the worksheet.
|
The OP did not ask to hide all 0s in the worksheet, only the "cell with a formula" by way of the "cell formating box". It was Kaneto that suggested the "entire worksheet" for conditional formatting. My suggestion was only intended for the formula cell; at least we agree on that. My warning was that relying on a custom format would also hide a zero result from the formula (if the result is meant to be zero) and not just from the input cells being blank.
Quote:
Originally Posted by macropod
I was quite deliberate in using the OR statement, for the reasons I gave. With your variant, if -A1=B1, you'll still get a 0 display.
|
As I said, sometimes the result is supposed to be "0", which is why I included the warning about the custom format. However with the OR statement in your example, if A1=0 and B1=4, your result would be "" instead of "4". Now that is "plain wrong".
01-19-2011, 12:24 PM
Similar Threads
Cell formatting
Windows XP 
Office 2003
Threaded Mode