Bug 32906 - conditional formatting should not be hard limited to 3 entries
Summary: conditional formatting should not be hard limited to 3 entries
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 release
Hardware: Other All
: medium enhancement
Assignee: Katarina Behrens
Whiteboard: feature target:3.5
Depends on:
Reported: 2011-01-07 14:39 UTC by Nicolò Chieffo
Modified: 2015-12-22 01:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Nicolò Chieffo 2011-01-07 14:39:36 UTC
It should be possible to set more than 3 conditional formatting entries.
Comment 1 Kohei Yoshida 2011-01-21 08:02:56 UTC
This is for Katarina.
Comment 2 mark 2011-03-02 08:23:49 UTC
Expanding conditional formatting beyond 3 entries would be so helpful!  I have a case where I need at least 6 conditional formatting entries, so I've been trying to write Basic Macros to accomplish this.  Writing the macros has been quite difficult, although I've learned a lot.
Comment 3 Anonymous Helper 2011-03-27 00:21:41 UTC
There is an extension for this: http://www.calc-info.de/makros.htm#mottco
Comment 4 Robert Cabane 2011-09-05 00:13:05 UTC
I agree, this would be valuable, really. 
But, anyway, shouldn't we do it as in Excel ?
("formatting cells based on their values")
Comment 5 Katarina Behrens 2011-09-05 02:30:01 UTC
3.5 is gonna have an unlimited no. of conditions for formatting
Comment 6 Robinson Tryon (qubit) 2015-12-22 01:37:35 UTC
Remove semicolon from Whiteboard.