LibreOffice Calc Conditional Formatting?

Charles Curley charlescurley at
Fri May 8 13:36:23 MDT 2015

On Thu, 7 May 2015 17:02:44 -0600
Charles Curley <charlescurley at> wrote:

> Is anyone else having problems with LibreOffice Calc Conditional
> Formatting? I have problems creating them anew, and also in copying
> them in from another spreadsheet. Are there any workarounds?

This turned out to be a documentation issue, rather than a bug. It
appears that when you test against a text string, you must put the text
string in double quotes.


The right of the people to be secure in their persons, houses, papers,
and effects, against unreasonable searches and seizures, shall not be
violated, and no Warrants shall issue, but upon probable cause,
supported by Oath or affirmation, and particularly describing the
place to be searched, and the persons or things to be seized.
-- U.S. Const. Amendment IV

Key fingerprint = CE5C 6645 A45A 64E4 94C0  809C FFF6 4C48 4ECD DFDB

More information about the PLUG mailing list