I am working on a series of Excel spreadsheets. Each sheet contains one column of text and each cell in that column can contain several lines of text. I'd like to search each sheet and if a specific string is found in the cell make the next cell contain "True".

How can this be done?

Thanks
ct