This can be actually done pretty easily with Conditional Formatting.

Use this formula for Excel 2007 and later (written for cell A1):

Use this formula for Excel 2003 and earlier (written for cell A1):Code:=IFERROR(FIND("MSCI",A1),0) > 0

Code:=IF(ISERROR(FIND("MSCI",A1)),0,1) > 0

## Like this thread? Share it with others