Hello
I have attached demo file with sheets names B2, B3 and B4.
I need to highlight duplicates of column A across all three sheets. How to do this please
Hello
I have attached demo file with sheets names B2, B3 and B4.
I need to highlight duplicates of column A across all three sheets. How to do this please
You can select column A and use Conditional formatting -> Highlight Cells Rules -> Duplicate values
I need to check duplicate across three sheets whether any sheet has common name in column A
I meant all three sheets it should check for duplicate
Three conditional formatting rules:
1. On the B2 sheet: =SUM(COUNTIFS('B3'!A$3:A$100,A2),COUNTIFS('B4'!A$3:A$100,A2))>0
2. On the B3 sheet: =SUM(COUNTIFS('B2'!A$3:A$100,A2),COUNTIFS('B4'!A$3:A$100,A2))>0
3. On the B4 sheet: =SUM(COUNTIFS('B2'!A$3:A$100,A2),COUNTIFS('B3'!A$3:A$100,A2))>0
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks