yogi_Dynamically Highlight Duplicate Entries in Column A Across All Tabs (Sheet1 Sheet2 Sheet3) Of A Spreadsheet


1	Sheet1	spreadsheet locale	question in Google Docs User Forum by 13245DM
2	quang	United States	http://productforums.google.com/forum/?zx=fvgkvgqvpzi3#!mydiscussions/docs/6RUZSlMx3nI
3	abc
4	sandy	this is cell B4
5	pete	Conditional Formatting For Cells A2:A to highlight duplicates in Sheet1
6	ric	Custom Formula is	=(countif(A$2:A2,A2)>1)*(A2<>"")	Format:	Text	Purple	Range:	A2:A
7	iinda				Background	Yellow
8	china
9	abc		note
10	kelly		in Sheet2 and Higher I have used VMerge custom written function
11	sulu		by ahab to merge the data from the previous sheets before
12	pete		applying the QUERY function
13	james
14	sandy


1	Sheet2	spreadsheet locale	question in Google Docs User Forum by 13245DM
2	quang	United States	http://productforums.google.com/forum/?zx=fvgkvgqvpzi3#!mydiscussions/docs/6RUZSlMx3nI
3	abc
4	sam	this is cell B4
5	pete	Conditional Formatting For Cells A2:A to highlight duplicates in Sheet1 to Sheet2
6	ric	Custom Formula is	=(countif(A$2:A2,A2)>1)*(A2<>"")+iferror(query(VMerge(indirect("Sheet1!A2:A")), "select count(Col1) where Col1 contains '"&A2&"' and Col1<>'' and '"&A2&"' <> '' label count(Col1) '' "),0)	Format:	Text	Purple	Range:	A2:A
7	iinda				Background	Yellow
8	sue
9	abc		note
10	kelly		in Sheet2 and Higher I have used VMerge custom written function
11	sue		by ahab to merge the data from the previous sheets before
12	pete		applying the QUERY function
13	james
14


1	Sheet3	spreadsheet locale	question in Google Docs User Forum by 13245DM
2	jim	United States	http://productforums.google.com/forum/?zx=fvgkvgqvpzi3#!mydiscussions/docs/6RUZSlMx3nI
3	beth
4	bill	this is cell B4
5	sue	Conditional Formatting For Cells A2:A to highlight duplicates in Sheet1 to Sheet3
6	kelly	Custom Formula is	=(countif(A$2:A2,A2)>1)*(A2<>"")+iferror(query(VMerge(indirect("Sheet1!A2:A"), indirect("Sheet2!A2:A")),"select count(Col1) where Col1 contains '"&A2&"' and Col1<>'' and '"&A2&"' <> '' label count(Col1) '' "),0)	Format:	Text	Purple	Range:	A2:A
7	ray				Background	Yellow
8	pasha
9	mala		note
10	lara		in Sheet2 and Higher I have used VMerge custom written function
11	uli		by ahab to merge the data from the previous sheets before
12	sunil		applying the QUERY function
13	rishi
14	leena
15	sam