Conditional Formatting by Date
-
- Posts: 3
- Joined: Mon Jul 15, 2019 7:33 pm
Conditional Formatting by Date
I would like to have a different color for past dates as well as blank cells ..which is why I need 5 conditions for example.
jc open office version 4.1.6
Re: conditional Formatting by Date
Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: conditional Formatting by Date
The first matching condition applies first, disregarding the other conditions.
less than today+7 is always matched before less than today+10
switch the 2 conditions.
less than today+7 is always matched before less than today+10
switch the 2 conditions.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: conditional Formatting by Date
There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/pr ... formatting
OpenOffice 4.1.6 on Windows 10 x64
Re: conditional Formatting by Date
The successor to OpenOffice https://libreoffice.org supports more than 3 conditions out of the box.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 3
- Joined: Mon Jul 15, 2019 7:33 pm
Re: conditional Formatting by Date
Thanks I downloaded it and installed it and when I got to use it I can add another condition however then when I go back to use it it says "editor or manager now under conditional formatting and cant actual tell it what to do with it now option to change color no longer available...sorry think on right track here but now cant tell it what color to change it to ?merlijn wrote:There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/pr ... formatting
jc open office version 4.1.6
-
- Posts: 3
- Joined: Mon Jul 15, 2019 7:33 pm