[Solved] Highlight cells containing specified words

[callkalpa]

hi all,

I've got a set of words (about 10) and a calc spreadsheet. I want to highlight cells in the spreadsheet which contains any of the words in the set.

Is this possible, if so how can I accomplish this task?

Thanks in advance.

[jrkrideau]

hi all,

I've got a set of words (about 10) and a calc spreadsheet. I want to highlight cells in the spreadsheet which contains any of the words in the set.

Is this possible, if so how can I accomplish this task?

Thanks in advance.

You might want to take a look at Conditional Formatting in Help. I'm not sure if it can handle 10 conditions but it may. Look under the Parameter subheading,

[acknak]

You can handle any number of words in a conditional expression by using a formula condition, something like this:
ISNUMBER(SEARCH("\<(a|an|the|that|those|these|this)\>";A19))

The text in red is a pattern (or, "regular expression") that matches any of the given words.

If the words can appear anywhere in the cell text, you can use a pattern like this:
.*\<(a|an|the|that|those|these|this)\>.*

Here's an example:

[callkalpa]

Thanks and it worked.