by Zizi64 » Wed Jan 10, 2018 1:14 am
in one of the columns of the table I would like to have different colors of numerical values, but as soon as I enter the fourth condition, all the code disappears. Is there any restriction to max 3 conditions?
I would like to get something like that:
[=1][BLACK]"a";[=2][RED]"b";[=3][GREEN]"c";[>3][BLUE]"d";
LibreOffice 4.2 on Windows7
The LibreOffice can handle more than 3 conditions in the CF function.
Can you upload your ODF type sample file here?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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.