I have a spreadsheet for work with a list of claims from the previous month. Column A on Sheet1 contains the employer's alphanumeric group# (A2-A501). Sheet2 contains just a list (A1-A46) of group#'s that don't need review, and I'd like to set a conditional rule so that any row on Sheet1 where the value in the A column matches any of the group#'s in Sheet2, then the entire row formats appropriately to what I set (in this case, highlights red).
I researched online, but couldn't find any that would fit my specific scenario that also worked.
Seems:
=MATCH($A2,vRange,0)
as a Conditional Formatting formula rule suited, where vRange
is the name of Workbook scope given to the relevant range in Sheet2.