diff options
| author | Jan Holesovsky <kendy@suse.cz> | 2010-08-18 18:02:49 +0200 |
|---|---|---|
| committer | Jan Holesovsky <kendy@suse.cz> | 2010-08-18 18:02:49 +0200 |
| commit | 327bf36baf0e310a6eba0557c7cffe41e55b5fee (patch) | |
| tree | f501ede93922f6b1bde9365a3dd11b4044b4d757 /helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp | |
| parent | 862388a7f3d7c8fd810d0d79c0fbc0267980fc78 (diff) | |
| parent | 9d52a4ec1b07ddaa93f9abb992e3e67ed8d79e77 (diff) | |
Merge commit 'ooo/OOO330_m4'
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp | 248 |
1 files changed, 126 insertions, 122 deletions
diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp index 10ac33ba85..1c1d38d508 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_conditional.xhp @@ -1,19 +1,15 @@ <?xml version="1.0" encoding="UTF-8"?> - - - +<helpdocument version="1.0"> + <!-- - *********************************************************************** +*********************************************************************** * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * - * Copyright 2008 by Sun Microsystems, Inc. + * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: cellstyle_conditional.xhp,v $ - * $Revision: 1.9 $ - * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify @@ -33,120 +29,128 @@ * ************************************************************************ --> - - - <helpdocument version="1.0"> + + <meta> -<topic id="textscalcguidecellstyle_conditionalxml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Applying Conditional Formatting</title> -<filename>/text/scalc/guide/cellstyle_conditional.xhp</filename> -</topic> -</meta> -<body> + <topic id="textscalcguidecellstyle_conditionalxml" indexer="include" status="PUBLISH"> + <title xml-lang="en-US" id="tit">Applying Conditional Formatting</title> + <filename>/text/scalc/guide/cellstyle_conditional.xhp</filename> + </topic> + </meta> + <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3149263"><bookmark_value>conditional formatting; cells</bookmark_value> -<bookmark_value>cells; conditional formatting</bookmark_value> -<bookmark_value>formatting; conditional formatting</bookmark_value> -<bookmark_value>styles;conditional styles</bookmark_value> -<bookmark_value>cell formats; conditional</bookmark_value> -<bookmark_value>random numbers;examples</bookmark_value> -<bookmark_value>cell styles; copying</bookmark_value> -<bookmark_value>copying; cell styles</bookmark_value> -<bookmark_value>tables; copying cell styles</bookmark_value> -</bookmark><comment>mw deleted "formats;"</comment><paragraph role="heading" id="hd_id3149263" xml-lang="en-US" level="1" l10n="U" oldref="24"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional Formatting">Applying Conditional Formatting</link> + <bookmark_value>cells; conditional formatting</bookmark_value> + <bookmark_value>formatting; conditional formatting</bookmark_value> + <bookmark_value>styles;conditional styles</bookmark_value> + <bookmark_value>cell formats; conditional</bookmark_value> + <bookmark_value>random numbers;examples</bookmark_value> + <bookmark_value>cell styles; copying</bookmark_value> + <bookmark_value>copying; cell styles</bookmark_value> + <bookmark_value>tables; copying cell styles</bookmark_value> +</bookmark><comment>mw deleted "formats;"</comment> +<paragraph xml-lang="en-US" id="hd_id3149263" role="heading" level="1" l10n="U" + oldref="24"><variable id="cellstyle_conditional"><link href="text/scalc/guide/cellstyle_conditional.xhp" name="Applying Conditional Formatting">Applying Conditional Formatting</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3159156" xml-lang="en-US" l10n="U" oldref="25">Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> -<paragraph role="warning" id="par_id8039796" xml-lang="en-US" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Tools - Cell Contents - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> -<paragraph role="paragraph" id="par_id3154944" xml-lang="en-US" l10n="U" oldref="26">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.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3154490" xml-lang="en-US" l10n="U" oldref="27">Select the cells to which you want to apply a conditional style.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3155603" xml-lang="en-US" l10n="U" oldref="28">Choose <emph>Format - Conditional Formatting</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3146969" xml-lang="en-US" l10n="U" oldref="29">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp" name="$[officename] Help">$[officename] Help</link>, and an example is provided below:</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3155766" xml-lang="en-US" level="2" l10n="U" oldref="38">Example of Conditional Formatting: Generate Number Values</paragraph> -<paragraph role="paragraph" id="par_id3150043" xml-lang="en-US" l10n="U" oldref="39">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.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3155337" xml-lang="en-US" l10n="U" oldref="40">First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers:</paragraph> -<paragraph role="listitem" id="par_id3149565" xml-lang="en-US" l10n="U" oldref="41">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).</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3149258" xml-lang="en-US" l10n="U" oldref="42">Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3159236" xml-lang="en-US" l10n="U" oldref="43">In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3149211" xml-lang="en-US" level="2" l10n="U" oldref="44">Example of Conditional Formatting: Define Cell Styles</paragraph> -<paragraph role="paragraph" id="par_id3154659" xml-lang="en-US" l10n="U" oldref="45">The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles and Formatting window is visible before proceeding.</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3150883" xml-lang="en-US" l10n="U" oldref="46">Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3155529" xml-lang="en-US" l10n="U" oldref="47">In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, select a background color. Click <emph>OK</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3154484" xml-lang="en-US" l10n="U" oldref="48">In the Styles and Formatting window, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style "Above".</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3152889" xml-lang="en-US" l10n="U" oldref="49">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").</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3148704" xml-lang="en-US" level="2" l10n="U" oldref="60">Example of Conditional Formatting: Calculate Average</paragraph> -<paragraph role="paragraph" id="par_id3148837" xml-lang="en-US" l10n="U" oldref="51">In our particular example, we are calculating the average of the random values. The result is placed in a cell:</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3144768" xml-lang="en-US" l10n="CHG" oldref="52">Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3156016" xml-lang="en-US" l10n="CHG" oldref="53">Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href="text/shared/00/00000001.xhp#eingabesymbol" name="Shrink or Maximize">Shrink / Maximize</link> icon.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3153246" xml-lang="en-US" l10n="U" oldref="54">Close Function Wizard with <emph>OK</emph>.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3149898" xml-lang="en-US" level="2" l10n="U" oldref="50">Example of Conditional Formatting: Apply Cell Style</paragraph> -<paragraph role="paragraph" id="par_id3149126" xml-lang="en-US" l10n="U" oldref="55">Now you can apply the conditional formatting to the sheet:</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3150049" xml-lang="en-US" l10n="U" oldref="56">Select all cells with the random numbers.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3153801" xml-lang="en-US" l10n="U" oldref="57">Choose the <emph>Format - Conditional Formatting</emph> command to open the corresponding dialog.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3153013" xml-lang="en-US" l10n="U" oldref="58">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".</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id3155761" xml-lang="en-US" level="2" l10n="U" oldref="61">Example of Conditional Formatting: Copy Cell Style</paragraph> -<paragraph role="paragraph" id="par_id3145320" xml-lang="en-US" l10n="U" oldref="62">To apply the conditional formatting to other cells later:</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="listitem" id="par_id3153074" xml-lang="en-US" l10n="U" oldref="63">Click one of the cells that has been assigned conditional formatting.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3149051" xml-lang="en-US" l10n="U" oldref="64">Copy the cell to the clipboard.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3150436" xml-lang="en-US" l10n="U" oldref="65">Select the cells that are to receive this same formatting.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3147298" xml-lang="en-US" l10n="U" oldref="66">Choose <emph>Edit - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears.</paragraph> -</listitem> -<listitem> -<paragraph role="listitem" id="par_id3166465" xml-lang="en-US" l10n="U" oldref="67">In the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>.</paragraph> -</listitem> -</list> -<section id="relatedtopics"> -<embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> -<embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> -<paragraph role="paragraph" id="par_id3159123" xml-lang="en-US" l10n="U" oldref="68"><link href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format - Conditional formatting</link></paragraph> -</section> -</body> -</helpdocument> + <paragraph xml-lang="en-US" id="par_id3159156" role="paragraph" l10n="U" oldref="25">Using the menu command <emph>Format - Conditional formatting</emph>, the dialog allows you to define up to three conditions per cell, which must be met in order for the selected cells to have a particular format.</paragraph> + <paragraph xml-lang="en-US" id="par_id8039796" role="warning" l10n="NEW">To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Tools - Cell Contents - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).</paragraph> + <paragraph xml-lang="en-US" id="par_id3154944" role="paragraph" l10n="U" oldref="26">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.</paragraph> + <paragraph xml-lang="en-US" id="hd_id4480727" role="heading" level="2" l10n="NEW">To Define the Conditions</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3154490" role="listitem" l10n="U" oldref="27">Select the cells to which you want to apply a conditional style.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155603" role="listitem" l10n="U" oldref="28">Choose <emph>Format - Conditional Formatting</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3146969" role="listitem" l10n="U" oldref="29">Enter the condition(s) into the dialog box. The dialog is described in detail in <link href="text/scalc/01/05120000.xhp" name="$[officename] Help">$[officename] Help</link>, and an example is provided below:</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3155766" role="heading" level="2" l10n="U" + oldref="38">Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value</paragraph> + <paragraph xml-lang="en-US" id="hd_id4341868" role="heading" level="3" l10n="NEW">Step1: Generate Number Values</paragraph> + <paragraph xml-lang="en-US" id="par_id3150043" role="paragraph" l10n="U" oldref="39">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.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155337" role="listitem" l10n="U" oldref="40">First of all, write a table in which a few different values occur. For your test you can create tables with any random numbers:</paragraph> + <paragraph xml-lang="en-US" id="par_id3149565" role="listitem" l10n="U" oldref="41">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).</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149258" role="listitem" l10n="U" oldref="42">Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3159236" role="listitem" l10n="U" oldref="43">In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3149211" role="heading" level="3" l10n="U" + oldref="44">Step 2: Define Cell Styles</paragraph> + <paragraph xml-lang="en-US" id="par_id3154659" role="paragraph" l10n="U" oldref="45">The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles and Formatting window is visible before proceeding.</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150883" role="listitem" l10n="U" oldref="46">Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3155529" role="listitem" l10n="U" oldref="47">In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, select a background color. Click <emph>OK</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3154484" role="listitem" l10n="U" oldref="48">In the Styles and Formatting window, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style "Above".</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3152889" role="listitem" l10n="U" oldref="49">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").</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3148704" role="heading" level="3" l10n="U" + oldref="60">Step 3: Calculate Average</paragraph> + <paragraph xml-lang="en-US" id="par_id3148837" role="paragraph" l10n="U" oldref="51">In our particular example, we are calculating the average of the random values. The result is placed in a cell:</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3144768" role="listitem" l10n="CHG" oldref="52">Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3156016" role="listitem" l10n="CHG" oldref="53">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 <link href="text/shared/00/00000001.xhp#eingabesymbol" name="Shrink or Maximize"><item type="menuitem">Shrink / Maximize</item></link> icon.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153246" role="listitem" l10n="U" oldref="54">Close the Function Wizard with <item type="menuitem">OK</item>.</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3149898" role="heading" level="3" l10n="U" + oldref="50">Step 4: Apply Cell Styles</paragraph> + <paragraph xml-lang="en-US" id="par_id3149126" role="paragraph" l10n="U" oldref="55">Now you can apply the conditional formatting to the sheet:</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150049" role="listitem" l10n="U" oldref="56">Select all cells with the random numbers.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153801" role="listitem" l10n="U" oldref="57">Choose the <emph>Format - Conditional Formatting</emph> command to open the corresponding dialog.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153013" role="listitem" l10n="U" oldref="58">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".</paragraph> + </listitem> + </list> + <paragraph xml-lang="en-US" id="hd_id3155761" role="heading" level="3" l10n="U" + oldref="61">Step 5: Copy Cell Style</paragraph> + <paragraph xml-lang="en-US" id="par_id3145320" role="paragraph" l10n="U" oldref="62">To apply the conditional formatting to other cells later:</paragraph> + <list type="ordered"> + <listitem> + <paragraph xml-lang="en-US" id="par_id3153074" role="listitem" l10n="U" oldref="63">Click one of the cells that has been assigned conditional formatting.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3149051" role="listitem" l10n="U" oldref="64">Copy the cell to the clipboard.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3150436" role="listitem" l10n="U" oldref="65">Select the cells that are to receive this same formatting.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3147298" role="listitem" l10n="U" oldref="66">Choose <emph>Edit - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears.</paragraph> + </listitem> + <listitem> + <paragraph xml-lang="en-US" id="par_id3166465" role="listitem" l10n="U" oldref="67">In the <emph>Selection</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>.</paragraph> + </listitem> + </list> + <section id="relatedtopics"> + <embed href="text/scalc/guide/cellstyle_by_formula.xhp#cellstyle_by_formula"/> + <embed href="text/scalc/guide/cellstyle_minusvalue.xhp#cellstyle_minusvalue"/> + <paragraph xml-lang="en-US" id="par_id3159123" role="paragraph" l10n="U" oldref="68"><link href="text/scalc/01/05120000.xhp" name="Format - Conditional formatting">Format - Conditional formatting</link></paragraph> + </section> + </body> +</helpdocument>
\ No newline at end of file |