Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

answered 2013-07-15 04:44:57 +0200

ROSt52 gravatar image

you might be able to use conditional formatting:

  • Select the area in which you have your numbers

  • click format / conditional formatting / condition

  • set condition to "less than" and "0"

-click on Applied Style which appears as "Default" and select "new style"

  • select in the style window a font color which matches your back ground color (I used white and call the new style (WhiteFont)

  • click OK and all numbers <0 will not be seen.

I recommend to read also in help file and help wiki.