Conditional Formatting by Date

[jc macgiver]

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.

[Zizi64]

Please upload your ODF type sample file here.

[Villeroy]

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.

[merlijn]

There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/pr ... formatting

[Villeroy]

The successor to OpenOffice https://libreoffice.org supports more than 3 conditions out of the box.

[jc macgiver]

There is an extension available that allows more than 3 conditions, https://extensions.openoffice.org/en/pr ... 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 macgiver]

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 155 times