Conditional Formatting by Date

Discuss the spreadsheet application

Conditional Formatting by Date

Postby jc macgiver » Mon Jul 15, 2019 8:00 pm

conditional formating rules.png
Hello Everyone Thanks in Advance for your Help. What I am trying to do is change (Background Color) in a cell based on a Date... I have gotten this to work in conditional formatting using the "today" statement eg( Today()+7) Today()+12) Today()+20) However it will only allow me to set 3 Rules/conditions
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
jc macgiver
 
Posts: 3
Joined: Mon Jul 15, 2019 7:33 pm

Re: conditional Formatting by Date

Postby Zizi64 » Mon Jul 15, 2019 9:38 pm

Please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8137
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: conditional Formatting by Date

Postby Villeroy » Mon Jul 15, 2019 9:43 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26968
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: conditional Formatting by Date

Postby merlijn » Mon Jul 15, 2019 9:51 pm

There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/project/extend-your-conditional-formatting
OpenOffice 4.1.6 on Windows 10 x64
merlijn
 
Posts: 28
Joined: Mon Jun 11, 2018 8:29 pm

Re: conditional Formatting by Date

Postby Villeroy » Mon Jul 15, 2019 9:57 pm

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, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26968
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: conditional Formatting by Date

Postby jc macgiver » Tue Jul 16, 2019 12:12 am

merlijn wrote:There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/project/extend-your-conditional-formatting

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 ?
jc open office version 4.1.6
jc macgiver
 
Posts: 3
Joined: Mon Jul 15, 2019 7:33 pm

Re: Conditional Formatting by Date

Postby jc macgiver » Tue Jul 16, 2019 12:21 am

test budget.ods
this is an example of what im trying to do I need to add a condition "color for empty cell and another color for past dates
(16.32 KiB) Downloaded 11 times
jc open office version 4.1.6
jc macgiver
 
Posts: 3
Joined: Mon Jul 15, 2019 7:33 pm


Return to Calc

Who is online

Users browsing this forum: robleyd and 22 guests