Hi all,
In a nutshell, I need to apply conditional formatting to a row (or multiple cells within a row if easier) using a match function, but only looking at the last 7 characters of each string (lookup value and lookup array)
I have an ID column in data set 1, and an ID column in data set 2...