I don't know of a way to achieve via conditional formatting. However, the
formulas as shown in these examples may help.

http://www.cellmatrix.net/index.php/...e_zero_values/

http://www.cellmatrix.net/index.php/...e_zero_values/

--
John Mansfield
http://cellmatrix.net





"JEFF" wrote:

Hello,

Is is possible to supress Data Labels (Values) via conditional formatting?
I tried an IF Statement that returned a blank ("" or " ") if the condition is
true. However, the value of zero still appears unless I completely delete
the cell's contents.........

Thanks.