Thread: A little Excel Problem.

Can I hide negitive but not posivtive values in cells?

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Qallupilluq" <Qallupilluq@discussions.microsoft.com> wrote in message
news:E8D652F9-0EF8-44CA-B711-1965F49005BE@microsoft.com...
> Can I hide negitive but not posivtive values in cells?

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/
_______



Nick Hodge wrote:

> 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
>

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

"Qallupilluq" wrote:

> Can I hide negitive but not posivtive values in cells?