Forum Discussion
vinoth1984
May 11, 2025Copper Contributor
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 ...
Excelonlineadvisor
May 12, 2025Iron Contributor
Select data A1:AQ2022 >> Go to Conditional Formatting >> Manage Rules >> New Rule >> Format only cell that contains
use the same method multiple times. If you want VBA, kindly DM