blob: 9b339b8a3a46639ce84c4ddbeb8a17ea9ef430eb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<meta>
<topic id="textscalc0105120000xml" indexer="include">
<title xml-lang="en-US" id="tit">Conditional Formatting</title>
<filename>/text/scalc/01/05120000.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id5008046" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatMenu" id="bm_id5008047" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/ConditionalFormatDialog" id="bm_id3152518" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/@@nowidget@@" id="bm_id3152518" localize="false"/>
<h1 id="hd_id51665407876959"><variable id="ConditionalFormattingh1"><link href="text/scalc/01/05120000.xhp" name="Conditional Formatting">Conditional Formatting</link></variable></h1>
<paragraph xml-lang="en-US" id="par_id3163710" role="paragraph"><variable id="bedingtetext"><ahelp hid=".">Use <emph>Conditional Formatting</emph> to define range-based conditions that determine which <link href="text/scalc/01/cell_styles.xhp" name="CellStyles_link">cell style</link> will be applied to each cell in a given range based on its contents.</ahelp></variable> The cell style corresponding to the first condition that evaluates to <emph>true</emph> is applied. Cell styles applied through Conditional Formatting override cell styles applied manually using the <link href="text/scalc/main0202.xhp" name="FormattingBar_link"><emph>Formatting Bar</emph></link> or the <link href="text/scalc/01/05100000.xhp" name="StylesSidebar_link"><emph>Styles</emph> sidebar</link>.</paragraph>
<paragraph xml-lang="en-US" id="par_id3163711" role="paragraph">You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If <emph>Condition 1</emph> is true based on the current cell contents, the corresponding cell style is applied. Otherwise, <emph>Condition 2</emph> is evaluated to determine if its corresponding style will be applied. If none of the conditions match cell contents, then no changes are made to the cell format.</paragraph>
<paragraph role="paragraph" id="par_id431642031216368">Conditional formats do not overwrite cell styles and direct formatting applied manually. They remain saved as cell properties and are applied when the cell matches no conditions or when you remove all conditional formats.</paragraph>
<warning id="par_id2414014">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</warning>
<h2 id="hd_id961662926287139">Cell range</h2>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionalcondition"/>
</section>
<h3 id="hd_id431662926282555">Range</h3>
<paragraph xml-lang="en-US" id="par_id31494138" role="paragraph">Defines the range of cells concerned by the conditional formatting. Click on the <emph>Shrink</emph> button to minimize the dialog box. Click again on the button to come back to the dialog box once the range is selected.</paragraph>
<bookmark xml-lang="en-US" branch="index" id="bm_id3153189"><bookmark_value>conditional formatting; conditions</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/list" id="bm_id5008050" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/edassign" id="bm_id5008055" localize="false"/>
<h2 id="hd_id71624649758112">Condition list</h2>
<paragraph xml-lang="en-US" id="par_id3149413" role="paragraph">List of the conditions defined for the cell range in order of evaluation. You can define as many conditions as you want.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/up" id="bm_id5008053" localize="false"/>
<h3 id="hd_id41624649786605">Up</h3>
<paragraph xml-lang="en-US" id="par_id3149414" role="paragraph"><ahelp hid=".">Increase priority of the selected condition.</ahelp></paragraph>
<h3 id="hd_id861624649792266">Down</h3>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/down" id="bm_id5008054" localize="false"/>
<paragraph xml-lang="en-US" id="par_id3149415" role="paragraph"><ahelp hid=".">Decrease priority of the selected condition.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/add" id="bm_id5008051" localize="false"/>
<h3 id="hd_id71662926011736">Add</h3>
<paragraph role="paragraph" id="par_id721662926016039">Adds the condition to the condition list.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalformatdialog/delete" id="bm_id5008052" localize="false"/>
<h3 id="hd_id401662926020291">Delete</h3>
<paragraph role="paragraph" id="par_id301662926026944">Deletes the condition from the condition list.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/conditionalentry/type" id="bm_id941662938267119" localize="false"/>
<h2 id="hd_id31531891">Condition list entries</h2>
<paragraph xml-lang="en-US" id="par_id31494132" role="paragraph">Specify if conditional formatting is dependent on one of the entry listed on the drop down box.</paragraph>
<embed href="text/scalc/01/05120100.xhp#cellvalueis"/>
<embed href="text/scalc/01/05120200.xhp#formulais"/>
<embed href="text/scalc/01/05120300.xhp#dateis"/>
<embed href="text/scalc/01/05120400.xhp#allcells"/>
<embed href="text/scalc/01/05120400.xhp#colorscale"/>
<embed href="text/scalc/01/05120400.xhp#databar"/>
<embed href="text/scalc/01/05120400.xhp#iconset"/>
<bookmark xml-lang="en-US" branch="modules/scalc/ui/conditionalentry/style" id="bm_id241662938779751" localize="false"/>
<h2 id="hd_id431662938949798">Apply Style</h2>
<paragraph role="paragraph" id="par_id971662939043786">Select the cell style to apply when the condition is verified. Select <emph>New Style</emph> to open the <link href="text/scalc/01/cell_styles.xhp" name="cellstyledialog">Cell Style dialog</link> and define the style properties.</paragraph>
<embed href="text/scalc/01/05120500.xhp#manageconditions"/>
<section id="relatedtopics">
<paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph" localize="false">
<embedvar href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/>
</paragraph>
</section>
</body>
</helpdocument>
|
