excel - VBA Find and Format Specific Text In Worksheet (Not entire Cell)

Question

I have a length table that uses data I've imported to complete calculation to help with inventory management. There is some text within item names that I would like to stand out. For Example, I have several item names that start with "Ingredient Flavor" and then end with a specific flavor name. I'd like the word Flavor to standout (different color, size, etc). There are other items that start with "Ingredient". There are items that start with "Material", "Merchandise", etc.

I think I need a loop that looks at each cell within the table, checks for the specific text, and formats the text if it finds it. There will be different texts to look for so I think I'd need to use cases.

Any suggestions on the best way to do this would be appreciated. Thanks!

标签： excelvba