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

Question

I'm looking for something that can highlight all cells/strings that contains a specific string. I'm using Calc on LibreOffice.

Answer 1

You can use conditional formatting with a simple equal to criteria.

The trick is to use quotation marks around the search string.

Step-by-step:

1. Select a range of cells,
2. In the menu, select the Format > Conditional Formatting > Condition entry,
3. Enter the string you want to match surrounded with quotation marks,
4. Select the style to use for highlighting, of create a new one for that purpose,
5. Click OK.