Conditional Formatting - highlighting word

[inezroque]

Hello,

I have Excel 2008 for Mac and want to do Conditional Formatting.

I want to highlight all cells that contain a certain word.

For example: I want to select all cells with the word "group". So, A2 which contains "group theme", A5 with "group meeting", etc.

I can do conditional formatting when the word matches exactly what I am looking for (ex: a cell including just the word "group"), but I don't know how to do it if the cells include other text.

Can you help me please?

Thank you,

Inês

 

[VoG]

Try the CF formula

=ISNUMBER(SEARCH("group",A1))