From 5d3d7401d26288e8bc7eb984dcd714590bc72e82 Mon Sep 17 00:00:00 2001 From: Rafael Lima Date: Thu, 13 Jan 2022 01:01:29 +0100 Subject: tdf#91230 Improve description of Conditional Formatting Change-Id: I536c959bec3ad94deb5e9893b956755d64f438f2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/128337 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/05120000.xhp | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'source/text/scalc/01') diff --git a/source/text/scalc/01/05120000.xhp b/source/text/scalc/01/05120000.xhp index ae62356fa9..b5fac35f18 100644 --- a/source/text/scalc/01/05120000.xhp +++ b/source/text/scalc/01/05120000.xhp @@ -32,12 +32,12 @@

Conditional Formatting

- Choose Conditional Formatting to define format styles depending on certain conditions. - If a style was already assigned to a cell, it remains unchanged. The style entered here is then evaluated. There are several types of conditional formatting that can be used. - You can enter several conditions that query the contents of cell values or formulas. The conditions are evaluated from the first to the last. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style is used. If this style does not match, then the next condition is evaluated and so on. -
- -
+ Use Conditional Formatting to define range-based conditions that determine which cell style will be applied to each cell in a given range based on its contents. The cell style corresponding to the first condition that evaluates to true is applied. Cell styles applied through Conditional Formatting override cell styles applied manulally using the Formatting Bar or the Styles sidebar. +
+ +
+ You can enter several conditions that query the cell values or results of formulas. The conditions are evaluated from first to the last. If Condition 1 is true based on the current cell contents, the corresponding cell style is applied. Otherwise, Condition 2 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. + Conditional formats do no 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. To apply conditional formatting, AutoCalculate must be enabled. Choose Data - Calculate - AutoCalculate (you see a check mark next to the command when AutoCalculate is enabled). conditional formatting; conditions -- cgit