Hi
supposing your range is A1:X100, and the column with text is col A, select the entire range, open the CF wizard and enter =ISNUMBER(SEARCH("SENT",$a1)) as formula.Format as needed - Exit the wizard - Done
( if you need a case sensitive function use FIND instead)
Adapt range and cell ref to your needs keeping in mind that the place of the $ sign is crucial
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|