Hi,
I have this test google sheet here: https://docs.google.com/spreadsheets...it?usp=sharing
There are two sheets, each with some words. In each sheet I'm using the following conditional formatting to display duplicates (the first instance of a duplicate is not shown):
In sheet 1 I would also like to display duplicate values if they occur in Sheet 2 (with a different fill color)![]()
Please Login or Register to view this content.
So for example, the word "blackberry" is not a duplicate in Sheet1, but it occurs in Sheet2 as well. So I'd like to show "blackberry" as a duplicate in Sheet 1
How can I do that?
Thanks
Bookmarks