2 things...
1. I need to: find a word/s within a sentence within a cell within a column if they are there. If they are not there, do nothing.... The search will need to cover the entire column searching through every entry in that column and and it's not column A but another column like column D. The sentences may or may not be the same.
---- Example Sentence1: The quick brown fox jumped over the lazy dog.
---- Example Sentance2: The lazy cat is upstairs on the bed.
---- Example Sentance3: Fourteen bags of wheat are needed and I don't know why.
---- The words to FIND are = fox quick dog lazy
Now, once it finds 1 or more of the words in each sentence, CAN those words only be BOLDED AND COLOR CHANGED TO RED
RESULT: The quick brown fox jumped over the lazy dog.
2. And Plan B, is to make the entire sentence bold and color/fill the entire cell yellow.
Bookmarks