diff options
| author | Ivo Hinkelmann <ihi@openoffice.org> | 2006-06-29 08:52:13 +0000 |
|---|---|---|
| committer | Ivo Hinkelmann <ihi@openoffice.org> | 2006-06-29 08:52:13 +0000 |
| commit | 7a18e89aaf10d6b756766deb89df109c0b86a41c (patch) | |
| tree | 22456f918e6f30a8f9f1823f6e43ffa5a8ab3be2 /helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp | |
| parent | fcbf5cfccc2825e832002bc01f587056e0a60c47 (diff) | |
INTEGRATION: CWS hcscalc01 (1.5.60); FILE MERGED
2006/05/29 14:51:05 ufi 1.5.60.1: *** empty log message ***
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp | 17 |
1 files changed, 10 insertions, 7 deletions
diff --git a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp index 5b70975e9e..6749f0fb2e 100755 --- a/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp +++ b/helpcontent2/source/text/scalc/guide/cellstyle_by_formula.xhp @@ -1,13 +1,14 @@ <?xml version="1.0" encoding="UTF-8"?> -<!--*********************************************************************** +<!-- + *********************************************************************** * * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: cellstyle_by_formula.xhp,v $ * - * $Revision: 1.5 $ + * $Revision: 1.6 $ * - * last change: $Author: kz $ $Date: 2005-10-05 12:08:04 $ + * last change: $Author: ihi $ $Date: 2006-06-29 09:50:37 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -32,7 +33,8 @@ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * - ************************************************************************--> + ************************************************************************ + --> <helpdocument version="1.0"> <meta> @@ -42,7 +44,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-08-08T13:58:02">converted from old format - fpe</lastedited> +<lastedited date="2006-05-15T16:31:14">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -51,10 +53,11 @@ <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulas</bookmark_value> <bookmark_value>formulas;assigning cell formats</bookmark_value> -</bookmark> +<bookmark_value>applying;cell formats</bookmark_value> +</bookmark><comment>mw added "applying;"</comment> <paragraph role="heading" id="hd_id3145673" xml-lang="en-US" level="1" l10n="U" oldref="13"><variable id="cellstyle_by_formula"><link href="text/scalc/guide/cellstyle_by_formula.xhp" name="Assigning Formats by Formula">Assigning Formats by Formula</link> </variable></paragraph> -<paragraph role="paragraph" id="par_id3150275" xml-lang="en-US" l10n="U" oldref="14">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3, "Red", "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> +<paragraph role="paragraph" id="par_id3150275" xml-lang="en-US" l10n="CHG" oldref="14">The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; "Red"; "Green")) applies the cell style "Red" to cells if the value is greater than 3, otherwise the cell style "Green" is applied.</paragraph> <paragraph role="paragraph" id="par_id3151385" xml-lang="en-US" l10n="U" oldref="15">If you would like to apply a formula to all cells in a selected area, you can use the<emph> Find & Replace</emph> dialog.</paragraph> <list type="ordered"> <listitem> |