VBA to highlight duplicates in columns

[Yamasaki450]

Hi guys. I did some Google search but cant find VBA i need so here i am again...

I need VBA to highlight duplicates in each column separately. I have quite large amount of data to process from B2 to VQN19.

I did first couple of columns manually with conditional formatting to show example... (see screenshot).

Than you...

 

[DanteAmor]

Use this formula:

=COUNTIF(B$2:B$19,B2)>1

Applies to:
=$B$2:$VQN$19

Example:

varios 02oct2024.xlsm
	B	C	D	E	F
2	17	22	101
3	20	33	102
4	37	1	103
5	17	2	104
6	1	3	105
7	2	4	106
8	3	5	107
9	4	1	105
10	5	39	109
11	6	40	110
12	7	41	111
13	8	42	112
14	9	43	113
15	5	44	114
16	6	45	115
17	7	46	116
18	22	47	117
19	33	48	118
Hoja4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:VQN19	Expression	=COUNTIF(B$2:B$19,B2)>1	text	NO

 

[Yamasaki450]

Use this formula:

=COUNTIF(B$2:B$19,B2)>1

Great. This also works.

Thanks a lot man... and have a nice day...