I have some data that contains a column which is Notes entered by CSR's. I would like to flag certain rows of data if the CSR puts in the notes that a customer has promised to fax something for instance. the Notes colum first contains the date stamp then the CSR name then then 1-2 sentences about the phone call. I would like to flag the cell if the word "Fax" appears anywhere in that cell. Can Excel do this with a basic formula?
Bookmarks