Ethen5155
03-24-2018, 07:26 AM
Hi all,
i'm seeking to find a macro way that can go through excel file with many segments with name for ex. (Project) then color all words inside all cells according to another excel file defined previously for ex. (keywords)
for ex
Project file contains cells as following:
1- Check out the examples of abstract nouns
2- Active voice describes a sentence where the subject
3- Comparative adjectives are used to compare
keywords file contains words as following:
abstract nouns
subject
Comparative adjectives
......etc
so i want to color only words (abstract nouns, subject, Comparative adjectives) from Project file
21906
Thanks i advance for helping
Cross-Posting: https://www.excelforum.com/excel-programming-vba-macros/1225318-find-and-color-text-with-text-list.html#post4870362
i'm seeking to find a macro way that can go through excel file with many segments with name for ex. (Project) then color all words inside all cells according to another excel file defined previously for ex. (keywords)
for ex
Project file contains cells as following:
1- Check out the examples of abstract nouns
2- Active voice describes a sentence where the subject
3- Comparative adjectives are used to compare
keywords file contains words as following:
abstract nouns
subject
Comparative adjectives
......etc
so i want to color only words (abstract nouns, subject, Comparative adjectives) from Project file
21906
Thanks i advance for helping
Cross-Posting: https://www.excelforum.com/excel-programming-vba-macros/1225318-find-and-color-text-with-text-list.html#post4870362