Conditional Formatting - Data Labels
 

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.

Conditional Formatting - Data Labels
 

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.

Conditional Formatting - Data Labels
 

Use a custom number format that omits zero values. These ignore everything
but positive values

0.00;;;
0;;;

More on number formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JEFF" wrote in message
...
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.