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