Hi,
In the table here -
I need in column A
The Excel will only highlight the cells for me
Which have words from the list in column F
This is an example of a particular table I have at work and there I need the tool that will design only the relevant cells for me.
How to do it ??
Thanks for the response!! Leah
Hello Lea,
It is quite simple when you get the hang of it.
First, I defined in the Name Manager the list of names to check against as Lookup, if you want this dynamic I suggest you create an Excel table.
Formula to use as rule in the conditional formatting is =SUM(COUNTIF(A2,"*"&Lookup&"*"))
The formula gives 1 as a result when there is a match, else a 0. And in Excel 1 = TRUE.
Br,
Anders
Thank you so much for the ingenious answer !!
I would love to understand the meaning of the signs you have inserted here in the formula -
"*" & Lookup & "*"
What does the * mean? And the &?
Thanks for the answer that will satisfy my curiosity.
Thanks!! Leah
Hello,
The asterisks are wildcard characters which makes it possible to make a fuzzy search. More info about wildcard characters in Excel can be found here. The & combines the asterisks with each content in the search range. There is a good blog post about all this here.
Br,
Anders
