1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 302dbb15cSAndrew Rist<!--*********************************************************** 4cdf0e10cSrcweir * 502dbb15cSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 602dbb15cSAndrew Rist * or more contributor license agreements. See the NOTICE file 702dbb15cSAndrew Rist * distributed with this work for additional information 802dbb15cSAndrew Rist * regarding copyright ownership. The ASF licenses this file 902dbb15cSAndrew Rist * to you under the Apache License, Version 2.0 (the 1002dbb15cSAndrew Rist * "License"); you may not use this file except in compliance 1102dbb15cSAndrew Rist * with the License. You may obtain a copy of the License at 12cdf0e10cSrcweir * 1302dbb15cSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 14cdf0e10cSrcweir * 1502dbb15cSAndrew Rist * Unless required by applicable law or agreed to in writing, 1602dbb15cSAndrew Rist * software distributed under the License is distributed on an 1702dbb15cSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1802dbb15cSAndrew Rist * KIND, either express or implied. See the License for the 1902dbb15cSAndrew Rist * specific language governing permissions and limitations 2002dbb15cSAndrew Rist * under the License. 21cdf0e10cSrcweir * 2202dbb15cSAndrew Rist ***********************************************************--> 2302dbb15cSAndrew Rist 24d1c38b03Smseidel<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textscalc0105120000xml" indexer="include"> 27cdf0e10cSrcweir<title xml-lang="en-US" id="tit">Conditional Formatting</title> 28cdf0e10cSrcweir<filename>/text/scalc/01/05120000.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id5008046" localize="false"/> 33cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/.uno:ConditionalFormatDialog" id="bm_id3147428" localize="false"/> 34*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3155132" role="heading" level="1" l10n="U">Conditional Formatting</paragraph> 35*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3163710" role="paragraph" l10n="U"><variable id="bedingtetext"><ahelp hid=".uno:ConditionalFormatDialog">Choose <emph>Conditional Formatting</emph> to define format styles depending on certain conditions.</ahelp> 36cdf0e10cSrcweir</variable> If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. You can enter three conditions that query the contents of cell values or formulas. The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated.</paragraph> 37cdf0e10cSrcweir<section id="howtoget"> 38cdf0e10cSrcweir<embed href="text/scalc/00/00000405.xhp#bedingte"/> 39cdf0e10cSrcweir</section> 40cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id2414014" role="warning" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose Tools - Cell Contents - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> 4182a98929Smseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153189"> 4282a98929Smseidel<bookmark_value>conditional formatting; conditions</bookmark_value> 43cdf0e10cSrcweir</bookmark> 44cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND1" id="bm_id3152598" localize="false"/> 45cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND2" id="bm_id3154490" localize="false"/> 46cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:CheckBox:RID_SCDLG_CONDFORMAT:CBX_COND3" id="bm_id3155415" localize="false"/> 47*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153189" role="heading" level="2" l10n="U">Condition 1/2/3</paragraph> 48*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3149413" role="paragraph" l10n="U"><ahelp hid="SC:CHECKBOX:RID_SCDLG_CONDFORMAT:CBX_COND3">Mark the boxes corresponding to each condition and enter the corresponding condition.</ahelp> To close the dialog, click <emph>OK</emph>.</paragraph> 49cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_1" id="bm_id3149581" localize="false"/> 50cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_1" id="bm_id3153158" localize="false"/> 51cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_1" id="bm_id3149379" localize="false"/> 52*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3147394" role="heading" level="2" l10n="U">Cell Value / Formula</paragraph> 53*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3155602" role="paragraph" l10n="U"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_1">Specifies if conditional formatting is dependent on a cell value or a formula.</ahelp> If you select a formula as a reference, the <emph>Cell Value Condition</emph> box is displayed to the right of the <emph>Cell value/Formula</emph> field. If the condition is "Formula is", enter a cell reference. If the cell reference is a value other than zero, the condition matches.</paragraph> 54cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_2" id="bm_id3153712" localize="false"/> 55cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_2" id="bm_id3145641" localize="false"/> 56cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_2" id="bm_id3154755" localize="false"/> 57*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3153709" role="heading" level="2" l10n="U">Cell Value Condition</paragraph> 58*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3153764" role="paragraph" l10n="U"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_2">Choose a condition for the format to be applied to the selected cells.</ahelp></paragraph> 59cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND1_TEMPLATE" id="bm_id3147345" localize="false"/> 60cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND2_TEMPLATE" id="bm_id3146918" localize="false"/> 61cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:ListBox:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE" id="bm_id3149257" localize="false"/> 62*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3156384" role="heading" level="2" l10n="U">Cell Style</paragraph> 63*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3145228" role="paragraph" l10n="U"><ahelp hid="SC:LISTBOX:RID_SCDLG_CONDFORMAT:LB_COND3_TEMPLATE">Choose the style to be applied if the specified condition matches.</ahelp></paragraph> 64cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND1_NEW" id="bm_id3149267" localize="false"/> 65cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND2_NEW" id="bm_id3149367" localize="false"/> 66cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:PushButton:RID_SCDLG_CONDFORMAT:BTN_COND3_NEW" id="bm_id3249267" localize="false"/> 67cdf0e10cSrcweir<paragraph xml-lang="en-US" id="hd_id0509200913175331" role="heading" level="2" l10n="NEW">New Style</paragraph> 68cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_id0509200913175368" role="paragraph" l10n="NEW"><ahelp hid=".">If you haven't already defined a style to be used, you can click New Style to open the Organizer tab page of the Cell Style dialog. Define a new style there and click OK.</ahelp></paragraph> 69cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_2" id="bm_id3150298" localize="false"/> 70cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_1" id="bm_id3147001" localize="false"/> 71cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND1_2" id="bm_id3154020" localize="false"/> 72cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND2_1" id="bm_id3159236" localize="false"/> 73cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_1" id="bm_id3149207" localize="false"/> 74cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_CONDFORMAT:EDT_COND3_2" id="bm_id3158212" localize="false"/> 75*17fc61f3Smseidel<paragraph xml-lang="en-US" id="hd_id3146316" role="heading" level="2" l10n="U">Parameter field</paragraph> 76*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3155114" role="paragraph" l10n="U"><ahelp hid="SC:EDIT:RID_SCDLG_CONDFORMAT:EDT_COND3_2" visibility="hidden">Enter a reference, value or formula.</ahelp> Enter a reference, value or formula in the parameter field, or in both parameter fields if you have selected a condition that requires two parameters. You can also enter formulas containing relative references.</paragraph> 77*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3145257" role="paragraph" l10n="U">Once the parameters have been defined, the condition is complete. It may appear as:</paragraph> 78*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3150784" role="paragraph" l10n="U">Cell value is equal 0: Cell style Null value (You must have already defined a cell style with this name before assigning it to a condition).</paragraph> 79*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3150365" role="paragraph" l10n="CHG">Cell value is between $B$20 and $B$21: Cell style Result (The corresponding value limits must already exist in cells B20 and B21).</paragraph> 80*17fc61f3Smseidel<paragraph xml-lang="en-US" id="par_id3152992" role="paragraph" l10n="CHG">Formula is SUM($A$1:$A$5)=10: Cell style Result (The selected cells are formatted with the Result style if the sum of the contents in cells A1 to A5 is equal to 10).</paragraph> 81cdf0e10cSrcweir<embed href="text/shared/00/00000001.xhp#eingabesymbol"/> 82cdf0e10cSrcweir<section id="relatedtopics"> 83cdf0e10cSrcweir<paragraph xml-lang="en-US" id="par_idN107E1" role="paragraph" l10n="NEW"> 84cdf0e10cSrcweir<embedvar href="text/scalc/guide/cellstyle_conditional.xhp#cellstyle_conditional"/> 85cdf0e10cSrcweir</paragraph> 86cdf0e10cSrcweir</section> 87cdf0e10cSrcweir</body> 88cdf0e10cSrcweir</helpdocument> 89