From 85aba709f71b6d1443db98fbacb22d9b47a71123 Mon Sep 17 00:00:00 2001 From: Roman Kuznetsov Date: Sat, 16 Jan 2021 20:46:59 +0100 Subject: tdf#139616 Updating a conditional formatting help page Change-Id: Id34c8e5e003802635e30a7e038d9f413625f1306 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/109404 Tested-by: Jenkins Reviewed-by: Adolfo Jayme Barrientos --- source/text/scalc/guide/cellstyle_conditional.xhp | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) (limited to 'source') diff --git a/source/text/scalc/guide/cellstyle_conditional.xhp b/source/text/scalc/guide/cellstyle_conditional.xhp index 0b7b0de315..c52d748d73 100644 --- a/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/source/text/scalc/guide/cellstyle_conditional.xhp @@ -39,7 +39,7 @@ mw deleted "formats;" Applying Conditional Formatting - Using the menu command Format - Conditional formatting, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format. + Using the menu command Format - Conditional - Condition, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format. 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). With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually. To Define the Conditions @@ -48,7 +48,7 @@ Select the cells to which you want to apply a conditional style. - Choose Format - Conditional Formatting. + Choose Format - Conditional - Condition. Enter the condition(s) into the dialog box. The dialog is described in detail in $[officename] Help, and an example is provided below: @@ -59,7 +59,7 @@ You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting. - First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers: + First of all, create a table in which a few different values occur. For your test you can create tables with any random numbers: In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50). @@ -76,10 +76,10 @@ Click in a blank cell and select the command Format Cells in the context menu. - In the Format Cells dialog on the Background tab, select a background color. Click OK. + In the Format Cells dialog on the Background tab, click the Color button and then select a background color. Click OK. - In the Styles window, click the New Style from Selection icon. Enter the name of the new style. For this example, name the style "Above". + In the Styles deck of the Sidebar, click the New Style from Selection icon. Enter the name of the new style. For this example, name the style "Above". To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, "Below"). @@ -92,7 +92,7 @@ Set the cursor in a blank cell, for example, J14, and choose Insert - Function. - Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the Shrink / Maximize icon. + Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the Shrink icon. Close the Function Wizard with OK. @@ -105,7 +105,7 @@ Select all cells with the random numbers. - Choose the Format - Conditional Formatting command to open the corresponding dialog. + Choose the Format - Conditional - Condition command to open the corresponding dialog. Define the condition as follows: If cell value is less than J14, format with cell style "Below", and if cell value is greater than or equal to J14, format with cell style "Above". @@ -124,16 +124,16 @@ Select the cells that are to receive this same formatting. - Choose Edit - Paste Special. The Paste Special dialog appears. + Choose Edit - Paste Special - Paste Special. The Paste Special dialog appears. - In the Selection area, check only the Formats box. All other boxes must be unchecked. Click OK. + In the Paste area, check only the Formats box. All other boxes must be unchecked. Click OK. Or you can click the Formats only button instead.
- Format - Conditional formatting + Format - Conditional - Condition
-- cgit