A little Excel Problem.

  • Thread starter Thread starter Guest
  • Start date Start date
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)
 
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/
_______
 
Use a custom format (Format, Cells, Number, choose custom format) such as
0.00;;; to hide negative numbers, zero values, and text.
 
Back
Top