blob: 41b9346c8bbcc51b0c342c02831f135e1dac8162 (
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
<?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="conditional formattingdateis" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Conditional Formatting - Date is</title>
<filename>/text/scalc/01/05120300.xhp</filename>
</topic>
</meta>
<body>
<bookmark branch="hid/.uno:CondDateFormatDialog" id="bm_id811700684279931" localize="false"/>
<section id="dateis">
<h1 id="hd_id321662936831682"><variable id="h1"><link href="text/scalc/01/05120300.xhp">Condition - Date is</link></variable></h1>
<paragraph role="paragraph" id="par_id31662934883939">Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the dropdown list.</paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#s_conditionaldate"/>
</section>
<list type="unordered">
<listitem>
<paragraph id="par_id231662933568615" role="listitem"><emph>Today</emph>: applies the cell style if the cell date contents is today.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id891662933647849" role="listitem"><emph>Yesterday</emph>: applies the cell style if the cell date contents is yesterday.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id701662933702962" role="listitem"><emph>Tomorrow</emph>: applies the cell style if the cell date contents is tomorrow.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id291662933755624" role="listitem"><emph>Last 7 days</emph>: applies the cell style if the cell date contents is in the last 7 calendar days.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id151662933849611" role="listitem"><emph>This week, Last week and Next week</emph>: applies the cell style if the cell date contents is in this week, last week and next week respectively. The start and end of the week is locale dependent.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id421662934429482" role="listitem"><emph>This month, Last month and Next month</emph>: applies the cell style if the cell date contents is in this month, last month and next month respectively.</paragraph>
</listitem>
<listitem>
<paragraph id="par_id461662934605639" role="listitem"><emph>This year, Last year and Next year</emph>: applies the cell style if the cell date contents is in this year, last year and next year respectively.</paragraph>
</listitem>
</list>
<section id="relatedtopics">
<paragraph role="paragraph" localize="false" id="par_id471665407993996"><embedvar href="text/scalc/01/05120000.xhp#ConditionalFormattingh1" markup="ignore"/></paragraph>
</section>
</body>
</helpdocument>
|
