Is it possible to look up a cells text, then check in a range and if there is a match highlight certain cells/rows
https://ibb.co/XyPkXDw
Lets say on the link that in the header "Country" is A1.
Currently using conditional formatting you can see some of the countries listed are highlighted, this is because they match the same country name in a range which starts from A100.
What i would like is for the code/formula to highlight A3:F3 if A3 matches a name in the range. Please note that the country name in A2, A3 etc can vary from day to day, but the color will always remain the same.
I've tried so many different type of formulas and codes for this, but to no avail. Any help would be appreciated.
https://ibb.co/XyPkXDw
Lets say on the link that in the header "Country" is A1.
Currently using conditional formatting you can see some of the countries listed are highlighted, this is because they match the same country name in a range which starts from A100.
What i would like is for the code/formula to highlight A3:F3 if A3 matches a name in the range. Please note that the country name in A2, A3 etc can vary from day to day, but the color will always remain the same.
I've tried so many different type of formulas and codes for this, but to no avail. Any help would be appreciated.
