[LibreOfficeCalc] Apply a style to a lign in function of the content of a cell

[Aurel89]

Hi everybody,

I want to use the conditional formatting in order that if the word “Disponibilty” is in the column K of one of the 400 first lign of my document, all the lign received the style “Disponibility”.

What I did :
I put in the condition the formula is $K2=“Disponibility”, in apply the style Disponibility (that I create for the occasion), and for the cell range A2:K200.

What I obtain :
For some lines it works, for others no. I don’t understand why. When I go back to “manage conditional formatting”, my previous rule has splite in many with different cell ranges. Someone can please give my an explanation ?

[JohnSUN]

What about condition formula is TRIM($K2)=“Disponibility”? Maybe you have some spaces after word “Disponibility”?

[Aurel89]

Thanks for your help but there is no space after the word. It was the only content of the cell.