Highlight Row Based On Word Found - Two Colors - Word Bank

[digital sol]

Hello, is there a method to configuring either conditional formatting or a macro in order to highlight an entire row based on a specified word list?

This would be ran on the entire workbook "Contains many pages"
-If any cell contains specific word 'TEST' change row color to green
-If any cell contains specific word 'Broken' change row color to red

Technically this search could be specified to any specific word found in Column E would highlight entire row in red/green based on match. Column E remains the correct filter column for the entire workbook.

I would run this against the entire workbook but also need to add a lot of words to this list. Say probably 15-25 for green and 15-25 for red. If no match found color would remain blank/no change.

Thanks I really appreciate the help, this will make this process much easier/faster to complete.

 

[digital sol]

t