i can't get the conditional formating to work. what im trying to do is look through each cell in a specific column and each cell that contains the word MSCI ( it will be one word in a phrase) highlight that row yellow. Does anyone know how to do this in VBA? Also i will need use this macro on numerous other spreedsheets is there a way to write it were it is available everytime excel is open and is not specific to this one spreadsheet?
Thanks for your time
Thanks for your time