Conditional Format for cells containing the same word (but in different phrases)

[joeyeti]

Hi,

trying to figure out how to apply a Conditional Format (or another way of highlighting) for cells, that contain the same word, but in different phrases - e.g. "Multitarget" and "Fixed multitarget".

Can this be done?

(The normal Cond. formatting formula I found for similar cells is like this: "=IF(COUNTIF(E4:M4, E4)>1,TRUE,FALSE)", but obviously does not work with the above in mind ).

Joe

[mikerickson]

How about a condition like this:
=(COUNTIF(A1,"=*multitarget*")=1)

[olasa]

Try this: =COUNTIF(E4:M4,"*"&E4&"*")>1 --> True or False
//Ola

[joeyeti]

Try this: =COUNTIF(E4:M4,"*"&E4&"*")>1 --> True or False
//Ola

Olasa (and mikerickson),

Thx! Needed to modify a little bit so that the range remains in every Cell the same (when I copied this to the Conditional Format in E4 and SHIFTed+R up to M4, the range of course changed in every cell, so had to manually change each to E4:M4 for it to work correctly), but now it is functioning splendid!

Joe