source/text/scalc/01/05120000.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit c4227d37acf1e07b49eea7ef7c955d919b18eabf
Author: Stéphane Guillou <stephane.guil...@member.fsf.org>
AuthorDate: Thu Nov 24 10:40:30 2022 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sun Nov 27 17:58:36 2022 +0100
tdf#152162: link from Conditional Formatting help to (Cell) Styles help
Change-Id: Ieaf4f4026ab29de490373946ff5a4428242b5dba
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143160
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/05120000.xhp
b/source/text/scalc/01/05120000.xhp
index 180b9f625b..9b339b8a3a 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -31,7 +31,7 @@
<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 cell style 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 <emph>Styles</emph> sidebar.</paragraph>
+ <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>
