I'm having a strange result in my conditional formatting.
I selected a COLUMN where the conditional formatting is needed.
I clicked on FORMAT > CONDITIONAL FORMATTING and in the dialog box put in > If the cell = 'JOE' then use style GREENBACKGROUND.
But then when I click OK, the entire column turns to green EXCEPT for ANY cell which is NOT empty.
Strange and not what I expected. Obviously I'm doing something the wrong way around - can anyone help?
Thanks!
[Solved] Conditional format strangeness
[Solved] Conditional format strangeness
Last edited by Hagar Delest on Thu May 02, 2019 11:01 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.0 on Windows 7
Re: conditional format strangeness
Please upload a real, ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
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.
Re: conditional format strangeness
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: conditional format strangeness
Just put double quotes around text : "Joe"
LibreOffice 6.4.5 on Windows 10
Re: conditional format strangeness
Perfect... and so simple when you know how! Thanks!gerard24 wrote:Just put double quotes around text : "Joe"
OpenOffice 4.1.0 on Windows 7
Re: conditional format strangeness
Here is why it works:gerard24 wrote:Just put double quotes around text : "Joe"
- When you test for equality to 'Joe' (or equality to Joe, i.e. unquoted), Calc takes it as a "data name" (cell, range, variable, etc.). Single quotes is only required when your data name contains spaces, but will always "dereference" the quoted content. If a name is undefined, the value returned is numerical zero. Numeric return from an empty cell is also zero. Hence, 'Joe' equals empty cells and the style is applied.
- When you test for equality to "Joe" (using double quotes), calc will take it as actual data and compare character by character. "Joe" does not equal an empty cell.
Re: Conditional format strangeness
Strangeness eliminated indeed! Thanks!
OpenOffice 4.1.0 on Windows 7