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
Bookmarks