Forum Discussion
highlight cells in a column, based on values in another sheet
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
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
Glad it could work 🙂 Please consider marking the discussion with an answer to potentially help future users.