hi all,
So basically put, I have 2 lists, one containing a list of areas nationally and a list of areas within my patch. I want to highlight cells within the national list if it appears within the my area list.
I would obviously usually use conditional formatting and highlight duplicates...