finding duplicates with conditional formatting

[smcexcel]

Hi All,

Thank you for reading this.

I am trying to spot recurring invoices, per-arranged by pivot table in columns. For example I list out daily transactions from July to Aug (60 columns) then I would have the vendor names listed in rows.

Now my question is if I want to quickly identify which vendors have recurring(duplicated amount) invoices. I would first select the vendor then click on conditional formatting and highlight duplicated value. But if I have over 2000 rows how can I quickly drag and autofill?? Is there a easier way or better formulas for this?

P.S I won't have a pre-identified value. I am just trying to spot recurring payments throughout different months for different vendors.

Please help....

 

[CA_Punit]

Book1
	B	C	D	E	F
20	Vendor	01-Aug	02-Aug	03-Aug	04-Aug
21	x	100	200	100	150
22	y	1000	200	200
23	z
24
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C21:F22	Expression	=COUNTIF($C21:$F21,C21)>1	text	NO

 

[smcexcel]

Book1
	B	C	D	E	F
20	Vendor	01-Aug	02-Aug	03-Aug	04-Aug
21	x	100	200	100	150
22	y	1000	200	200
23	z
24
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C21:F22	Expression	=COUNTIF($C21:$F21,C21)>1	text	NO

Thanks, CA_Punit.

Question, in your above conditional formatting. You have an identifier "C21" for your row 21.

For row 22, do you have to change the identifier again?

Secondly how do you bring up the second interface"Cells with conditional Formatting? For me when I add new rules. it has

below selection.

 

[CA_Punit]

Select Use a formula to determine which cell to format

So Step 1: Select Whole Range From C1 to K100(Say) where Invoice value Lie

The Formula Countif($C1:$K1,C1)>1 (The ranges are imaginary) (Modify it) put in "Use a formula to determine which cell to format" while selecting the range C1:K100

and Format the cell with colour and Press Enter