I have a large set of data in one column (K), containing random values of
1, 2, 3, and 4. Within that, I would like to locate and highlight sets of rows that match the values from a much smaller column (G) of data.
I tried using Conditional Formatting but was only able to set rules for single rows of data, not matching groups.
Within one Column (K), I expect to locate and highlight all instances of the data I put into another Column (G) (example
1, 2, 1, 1, 2).