Conditional formating on text values

[Geezer34]

Hi guys,

Been hunting around the forums but cant seem to find quite what I want.

I want to specify the background of a cell to be red if the text in that cell contains a specific word.

e.g. cell a1 will have the text 'Rest of World' (without quotes). I want this to show as red if it contains the word 'of'.

Of course the cell may contain other words but this illustrates what I'm looking to achieve.

I tried the following conditional formula but this does not work:

=IF(SEARCH("of",H3)>1,1,0)

Thanks for feedback :-)

[sweep]

Hi,

This wrks for me:

=FIND("of",H3)

[Geezer34]

Yep that certainly works for a cell that has that text in. Unfortunatley it also modifies those cells that does not have that text in i.e. UK/Europe.

Any other ideas about the formula I need to use?

[sweep]

I can't recreate this performance. What is the range of cells to which you are applying the conditional format? Are there any other conditional formats currently active?

[Geezer34]

mmmm Not sure why the spreadsheet in question has issues - I cant find any other formating. I can get a new spreadsheet to work correctly. I'll dig around and see what I can find.

BTW - is there any easy way to apply conditional formating to a range of cells e.g A1:A30?

UPDATED - of course there is. I had the answer in my question....