Ask Your Question

conditional formatting in calc doesn't work [closed]

asked 2013-01-14 08:54:33 +0200

ROSt52 gravatar image

updated 2015-10-20 00:58:43 +0200

Alex Kemp gravatar image

I defined a list of words and used data/validity/criteria = cell range, enter cell range as source; other tabs left default For each cell in a column I can select one of words listed. So far all works fine.

Next I want the background color and font color of the cell change according to the word selected for each cell.

"word" is a string of alpha characters, no numbers, no special characters

Steps done: check: tools/cell content/autocalculate select cell for conditional formatting select format/conditional formatting/ add: cell value | equal to | word 1 of my list apply style | new | select background color and font color | click OK add: ... continue the same procedure for each word in my list.

All seems to be OK but the back ground color and font color does not change.

What did a do wrong?

Thanks in advance for hints.

LibO on XP/ SP3

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 00:59:02.264348


Do you add a separate new style for each word in the list? Perhaps you would be more convenient to use the STYLE()... What values ​​are set in Tools - Options - LibreOffice Calc - Calculate?

JohnSUN gravatar imageJohnSUN ( 2013-01-14 12:04:38 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-01-14 16:13:17 +0200

JohnSUN gravatar image

I was referring to the use the functions Style in the conditional formatting formula - CondFormat with STYLE example.ods

edit flag offensive delete link more

answered 2013-01-15 10:14:09 +0200

ROSt52 gravatar image


your example is one solution. Thanks for creating the example sheet. I need to study a bit more about the STYLE function which seems to be an alternative to "normal" conditional formatting.

While looking into the STYLE function I found also what I made wrong in my first attempt

My line copied from my quesiton:

format/conditional formatting/ add: cell value | equal to | word 1....

the string >word 1< must be written as >"word 1"< to be recognized as a string. This is quiet normal I just did not think about it.

When working on my solution I actually saw how convenient it is in Calc (compared to EXCEL) to be able to use cell style for conditional formating even without the STYLE function.

Thanks for your support - you help to my way of thinking in the right direction.

edit flag offensive delete link more

answered 2013-01-14 14:26:55 +0200

ROSt52 gravatar image

@JohnSUN: Thanks for the hint with the styles. The list of words is short about 5 - 7 and working with styles is in this case too cumbersome. In MS Excel could use it the way I described in my original question.

I am sure it should work also in Calc, I just don't find the last missing part.

edit flag offensive delete link more

Question Tools


Asked: 2013-01-14 08:54:33 +0200

Seen: 4,230 times

Last updated: Jan 15 '13