Forum Discussion
Solved
highlight cells in a column, based on values in another sheet
Hi, i have a worksheet, one sheet ("Tracker") has a row in column E with numbers that i would like to match in a seperate sheet called "Palletainer Lookup" whereby anything that matches any numbers f...
Hi, attaching a sample document for you to check! The formula you should use can be something like:
=ISNUMBER(XMATCH($E2,'Palletainer Lookup'!$A$2:$A$7))
It is important to note absolute/relative references on the formulation. Note that I wrote $E2 and not $E$2.
Then, write a wide range in the section of "Applies to", just as I did.
Hope it works to you.
Martin
Thanks Martin, that worked perfectly. amazing 🙂
Glad it could work 🙂 Please consider marking the discussion with an answer to potentially help future users.