diff options
Diffstat (limited to 'source/text/scalc/guide/cellstyle_minusvalue.xhp')
-rw-r--r-- | source/text/scalc/guide/cellstyle_minusvalue.xhp | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/source/text/scalc/guide/cellstyle_minusvalue.xhp b/source/text/scalc/guide/cellstyle_minusvalue.xhp new file mode 100644 index 0000000000..a133ce25b3 --- /dev/null +++ b/source/text/scalc/guide/cellstyle_minusvalue.xhp @@ -0,0 +1,65 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- +*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + +<meta> + <topic id="textscalcguidecellstyle_minusvaluexml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Highlighting Negative Numbers</title> + <filename>/text/scalc/guide/cellstyle_minusvalue.xhp</filename> + </topic> + </meta> + <body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3147434"><bookmark_value>negative numbers</bookmark_value> + <bookmark_value>numbers; highlighting negative numbers</bookmark_value> + <bookmark_value>highlighting;negative numbers</bookmark_value> + <bookmark_value>colors;negative numbers</bookmark_value> + <bookmark_value>number formats;colors for negative numbers</bookmark_value> +</bookmark><comment>MW made "negative numbers;" a one level entry</comment><comment>MW changed "numbers formats;" and "colors;"</comment> +<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1" l10n="U" + oldref="31"><variable id="cellstyle_minusvalue"><link href="text/scalc/guide/cellstyle_minusvalue.xhp" name="Highlighting Negative Numbers">Highlighting Negative Numbers</link> +</variable></paragraph> + <paragraph xml-lang="en-US" id="par_id3153878" role="paragraph" l10n="U" oldref="33">You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155600" role="listitem" l10n="U" oldref="34">Select the cells and choose <emph>Format - Cells</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3146969" role="listitem" l10n="U" oldref="35">On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</emph>.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="par_id3145640" role="paragraph" l10n="U" oldref="36">The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type="menuitem">Format code</item>. For example, instead of RED, enter <item type="literal">YELLOW</item>. If the new code appears in the list after clicking the <item type="menuitem">Add</item> icon, this is a valid entry.</paragraph> + <section id="relatedtopics"> + <embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> + <embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> + </section> + </body> +</helpdocument>
\ No newline at end of file |