summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/05120000.xhp
diff options
context:
space:
mode:
authorDione Maddern <dionemaddern@gmail.com>2024-07-03 16:17:43 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2024-07-11 15:37:39 +0200
commitb719a26a02e1789d393a33156ab43a6b9d43b094 (patch)
tree9b67dbca8e34b21c2af7b1813377aa56df57b607 /source/text/scalc/01/05120000.xhp
parent1a7045ca49e06f1e84bee74cdac6d8d6a399ddd8 (diff)
Consolidate help pages for the Styles Sidebar deck into one page
Create new page text/shared/01/styles.xhp Delete pages - text/scalc/01/05100000.xhp - text/simpress/01/05100000.xhp - text/swriter/01/05140000.xhp In AllLangHelp_scalc - Remove reference to text/scalc/01/05100000.xhp In AllLangHelp_shared - Add entry for text/shared/01/styles.xhp In AllLangHelp_simpress - Remove reference to text/simpress/01/05100000.xhp In AllLangHelp_swriter.mk - Remove reference to text/simpress/01/05100000.xhp In source/text/scalc/01/cell_styles.xhp - Add variable tags to H1 to allow the page to be more easily linked from other pages. In text/swriter/01/05130000.xhp - Add variable and link tags to H1 so that the page can be more easily linked from other pages. Replace links to deleted page text/scalc/01/05100000.xhp with links to text/shared/01/styles.xhp in: - text/scalc/01/05120000.xhp - text/scalc/main0103.xhp - text/shared/01/05140100.xhp - text/shared/02/01230000.xhp Replace links to deleted page text/simpress/01/05100000.xhp with links to text/shared/01/styles.xhp in: - text/sdraw/main0103.xhp - text/sdraw/main_format.xhp - text/shared/01/05140100.xhp - text/shared/02/01230000.xhp - text/simpress/guide/masterpage.xhp - text/simpress/main0103.xhp Replace links to deleted page text/swriter/01/05140000.xhp with links to text/shared/01/styles.xhp in: - text/shared/01/05030000.xhp - text/shared/01/05040100.xhp - text/shared/01/05060000.xhp - text/shared/02/02010000.xhp - text/shared/menu/style_menu.xhp - text/swriter/01/05030800.xhp - text/swriter/01/05130000.xhp - text/swriter/01/05130004.xhp - text/swriter/main0103.xhp - text/swriter/main0503.xhp Change-Id: I20fc2a142107b3984abf1491459f3f485cd01f46 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/169950 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/05120000.xhp')
-rw-r--r--source/text/scalc/01/05120000.xhp2
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp
index 2a8940be32..13ae420e7b 100644
--- a/source/text/scalc/01/05120000.xhp
+++ b/source/text/scalc/01/05120000.xhp
@@ -34,7 +34,7 @@
<h1 id="hd_id51665407876959"><variable id="ConditionalFormattingh1"><link href="text/scalc/01/05120000.xhp">Conditional Formatting</link></variable></h1>
<paragraph 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">cell style</link> will be applied to each cell in a given range based on its contents.</ahelp></variable></paragraph>
</section>
- <paragraph role="paragraph" id="par_id411701538725496">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"><emph>Formatting Bar</emph></link> or the <link href="text/scalc/01/05100000.xhp"><emph>Styles</emph> sidebar</link>.</paragraph>
+ <paragraph role="paragraph" id="par_id411701538725496">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"><emph>Formatting Bar</emph></link> or the <link href="text/shared/01/styles.xhp"><emph>Styles</emph> sidebar</link>.</paragraph>
<paragraph 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>