G'day
I have been using Conditional Formatting > Highlight Cell Rules to highlight unique names when comparing two columns. The two columns represents current employees vs previous employees. The amount of data in these columns is huge.
I have run into an issue where there are people on the lists with the same name, so this won't be highlighted. Is there an option to compare columns row by row and have the unique entries highlighted?
Apologies if I haven't made clear what I'm attempting to achieve.
I have been using Conditional Formatting > Highlight Cell Rules to highlight unique names when comparing two columns. The two columns represents current employees vs previous employees. The amount of data in these columns is huge.
I have run into an issue where there are people on the lists with the same name, so this won't be highlighted. Is there an option to compare columns row by row and have the unique entries highlighted?
Apologies if I haven't made clear what I'm attempting to achieve.