libreoffice calc - How to highlight a cell if there is a specific word inside? -

i'm looking can highlight cells/strings contains specific string. i'm using calc on libreoffice.

you can use conditional formatting simple equal to criteria.

the trick use quotation marks around search string.

step-by-step:

1. select range of cells,
2. in menu, select format > conditional formatting > condition entry,
3. enter string want match surrounded quotation marks,
4. select style use highlighting, of create new 1 purpose,
5. click ok.