Conditional formatting in calc doesn't work

[ROSt53]

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 3.6.4.3 on XP/ SP3

[JohnSUN]

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]

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

[ROSt53]

@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.

[ROSt53]

@JohnSUN

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.