blob: 90c9c5d15af93d64d2be27271ae9e530e4968eb3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
-->
<meta>
<topic id="pageconditionalformattingformulais" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Conditional Formatting - Formula is</title>
<filename>/text/scalc/01/05120200.xhp</filename>
</topic>
</meta>
<body>
<bookmark id="bm_id221662936567368" xml-lang="en-US" branch="hid/zzzz" localize="false"/>
<section id="formulais">
<h1 id="hd_id471662936567369"><variable id="h1"><link href="text/scalc/01/05120200.xhp" name="Formula is">Condition - Formula is</link></variable></h1>
<paragraph xml-lang="en-US" id="par_id31494139" role="paragraph">Applies the selected style to the cell when the formula expression in the text box in the right is <emph>not</emph> zero.</paragraph>
</section>
<paragraph role="paragraph" id="par_id1001662932287796">The formula is expressed similar to a test condition evaluating to <literal>TRUE</literal> or <literal>FALSE</literal>.</paragraph>
<paragraph role="paragraph" id="par_id111662936728630">For example, if C29 has a conditional formatting which formula is <input>B1>=(DATE(2015;5;4)+TIME(18;0;0))</input> - a logical expression that evaluates true or false - the style applied to C29 depends on B1 contents.</paragraph>
</body>
</helpdocument>
|