Hi,
I'm trying to find a formula that would change the color of one cell based on multiple words found in a row. For example A1 would turn red if any cell from A2:H2 contains any of the following anywhere in the cell "BKN001,"1/4","TS","35" etc... Your help is appreciated.
Bookmarks