How do I find duplicated entries on mutiple sheets in same workbook

[ghrek]

Hi

I have a workbook that has sheet called "WATFORD" "TABLEAU" AND "PREV REC".

What im trying to do is to look down each sheet individually automatically on column A and if there any duplicated entries I need that row highlighting in yellow.

Any Ideas?

 

[etaf]

you could add conditional froamtting to each sheet

down each sheet individually automatically on column A

As its just each sheet and not referencing other sheets

The a simple countif() should do for you
got to sheet WATFORD

then select the range in column A - say A2:A1000 -
now use a countif
=COUNTIF($A$2:$A$1000, A2 ) > 1

Book2
	A
2	A1
3	A2
4	A3
5	A4
6	A5
7	A6
8	A7
9	A8
10	A9
11	A10
12	A11
13	A1
14	A12
15	A13
16	A14
17	A4
18	A3
watford

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A18	Expression	=COUNTIF($A$2:$A$18,A2)>1	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTIF($A$2:$A$1000, A2 ) > 1

Format [Number, Font, Border, Fill] format Yellow
choose the format you would like to apply when the condition is true
OK >> OK

Repeat for the other sheets



If you need all the row
Then select the Range
Highlight applicable range >>
A2:Z100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTIF($A$2:$A$1000, $A2 ) > 1

Format [Number, Font, Border, Fill] format Yellow
choose the format you would like to apply when the condition is true
OK >> OK

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2	A1
3	A2
4	A3
5	A4
6	A5
7	A6
8	A7
9	A8
10	A9
11	A10
12	A11
13	A1
14	A12
15	A13
16	A14
17	A4
18	A3
watford

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:Z18	Expression	=COUNTIF($A$2:$A$18,$A2)>1	text	NO