A little Excel Problem.

[Guest]

Can I hide negitive but not posivtive values in cells?

 

[Nick Hodge]

Using Conditional Formatting (Format>Conditional formatting...) set the cell
value to less than 0 and set the font format to white (Presuming no colour
in cell background... if there is use this colour). The data will still be
there but invisible. It will print though

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Jon Peltier]

To prevent the value from printing, use a custom number format. Select
the range, go to Cells on the Format menu, and click on the Number tab
of the dialog that pops up. A custom number format consists of four
parts, separated by semicolons. The first part is for positive numbers,
the second for negatives, the third for zeros, and the fourth for text.
A format that hides negative numbers would look like one of these:

0.00;;0.00;@
0;;0;@
General;;General;@

More about number formats:

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

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

 

[Guest]

Use a custom format (Format, Cells, Number, choose custom format) such as
0.00;;; to hide negative numbers, zero values, and text.