Forum Discussion
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 from the Palletainer Lookup sheet in column A is highlighted in purple on the tracker sheet in column E.
i have looked at various posts and i believe its around the conditional formatting but i cannot fathom the correct formula !
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
3 Replies
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.
