1<?xml version="1.0" encoding="UTF-8"?>
| 1<?xml version="1.0" encoding="UTF-8"?>
|
2<helpdocument version="1.0"> 3
| 2
|
4<!--***********************************************************
| 3<!--***********************************************************
|
5 *
| 4 *
|
6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information 9 * regarding copyright ownership. The ASF licenses this file 10 * to you under the Apache License, Version 2.0 (the 11 * "License"); you may not use this file except in compliance 12 * with the License. You may obtain a copy of the License at
| 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at
|
13 *
| 12 *
|
14 * http://www.apache.org/licenses/LICENSE-2.0
| 13 * http://www.apache.org/licenses/LICENSE-2.0
|
15 *
| 14 *
|
16 * Unless required by applicable law or agreed to in writing, 17 * software distributed under the License is distributed on an 18 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19 * KIND, either express or implied. See the License for the 20 * specific language governing permissions and limitations 21 * under the License.
| 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License.
|
22 *
| 21 *
|
23 ***********************************************************--> 24
| 22 ***********************************************************--> 23
|
25 26 27
| 24<helpdocument version="1.0">
|
28<meta>
| 25<meta>
|
29 <topic id="textscalcguidecellstyle_minusvaluexml" indexer="include" status="PUBLISH"> 30 <title xml-lang="en-US" id="tit">Highlighting Negative Numbers</title> 31 <filename>/text/scalc/guide/cellstyle_minusvalue.xhp</filename> 32 </topic> 33 </meta> 34 <body> 35<bookmark xml-lang="en-US" branch="index" id="bm_id3147434"><bookmark_value>negative numbers</bookmark_value> 36 <bookmark_value>numbers; highlighting negative numbers</bookmark_value> 37 <bookmark_value>highlighting;negative numbers</bookmark_value> 38 <bookmark_value>colors;negative numbers</bookmark_value> 39 <bookmark_value>number formats;colors for negative numbers</bookmark_value>
| 26<topic id="textscalcguidecellstyle_minusvaluexml" indexer="include" status="PUBLISH"> 27<title xml-lang="en-US" id="tit">Highlighting Negative Numbers</title> 28<filename>/text/scalc/guide/cellstyle_minusvalue.xhp</filename> 29</topic> 30</meta> 31<body> 32<bookmark xml-lang="en-US" branch="index" id="bm_id3147434"> 33<bookmark_value>negative numbers</bookmark_value> 34<bookmark_value>numbers; highlighting negative numbers</bookmark_value> 35<bookmark_value>highlighting;negative numbers</bookmark_value> 36<bookmark_value>colors;negative numbers</bookmark_value> 37<bookmark_value>number formats;colors for negative numbers</bookmark_value>
|
40</bookmark><comment>MW made "negative numbers;" a one level entry</comment><comment>MW changed "numbers formats;" and "colors;"</comment> 41<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1" l10n="U"
| 38</bookmark><comment>MW made "negative numbers;" a one level entry</comment><comment>MW changed "numbers formats;" and "colors;"</comment> 39<paragraph xml-lang="en-US" id="hd_id3147434" role="heading" level="1" l10n="U"
|
42 oldref="31"><variable id="cellstyle_minusvalue"><link href="text/scalc/guide/cellstyle_minusvalue.xhp" name="Highlighting Negative Numbers">Highlighting Negative Numbers</link>
| 40oldref="31"><variable id="cellstyle_minusvalue"><link href="text/scalc/guide/cellstyle_minusvalue.xhp" name="Highlighting Negative Numbers">Highlighting Negative Numbers</link>
|
43</variable></paragraph>
| 41</variable></paragraph>
|
44 <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> 45 <list type="ordered"> 46 <listitem> 47 <paragraph xml-lang="en-US" id="par_id3155600" role="listitem" l10n="U" oldref="34">Select the cells and choose <emph>Format - Cells</emph>.</paragraph> 48 </listitem> 49 <listitem> 50 <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> 51 </listitem> 52 </list> 53 <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> 54 <section id="relatedtopics"> 55 <embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 56 <embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> 57 </section> 58 </body>
| 42<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> 43<list type="ordered"> 44<listitem> 45<paragraph xml-lang="en-US" id="par_id3155600" role="listitem" l10n="U" oldref="34">Select the cells and choose <emph>Format - Cells</emph>.</paragraph> 46</listitem> 47<listitem> 48<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> 49</listitem> 50</list> 51<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> 52<section id="relatedtopics"> 53<embed href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 54<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> 55</section> 56</body>
|
59</helpdocument>
| 57</helpdocument>
|