Forum Discussion
How to conditional format any cell in an excel file based on the list of words I have.
I have an excel data that have columns A to AQ and rows 1 to 2022. Means that my data range is A1 to AQ2022. On the other side i have 50 words list, i want an formula to search for these 50 words in ...
The attached file shows an example for range A1:J36 where each cells that contains a word from range L1:L19 is highlighted in orange. The ranges and the rule for conditional formatting can be adjusted as required.
As variant, rule formula could be
=SUM( COUNTIF( A1, "*" & $L$1:$L$19 & "*") )
