Highlight duplicate values ignoring first Occurrence value in Excel

[HappyWilliam]

Hello Everyone,

Please can someone help me figure this out. Would like a formula/vba code for my conditional Formatting to highlight duplicates within a range but ignoring first occurrences

Check A	Check B	Check C	Check D	Check E	Check F	Check G	Check H
2	15	23	8	14	21	22	38
4	13	48	56	45	2	65	70
10	11	56	42	32	37	52	99
22	53	7	47	50	59	67	90
55.5	2	45	100	115	145	73	48
99	88	59	13	33	39	49	50
4	55.5	70	51	81	64	120	115
2	11	40	52	25	35	99	65

thanks in advance

 

[CSmith]

By entire row or single cell in column?

 

[HappyWilliam]

within the range B4:I11 (from 2 under CheckA to 65 In Check H)

 

[kevin9999]

Not 100% sure what you're after, but is this it?

Book1
	B	C	D	E	F	G	H	I
3	Check A	Check B	Check C	Check D	Check E	Check F	Check G	Check H
4	2	15	23	8	14	21	22	38
5	4	13	48	56	45	2	65	70
6	10	11	56	42	32	37	52	99
7	22	53	7	47	50	59	67	90
8	55.5	2	45	100	115	145	73	48
9	99	88	59	13	33	39	49	50
10	4	55.5	70	51	81	64	120	115
11	2	11	40	52	25	35	99	65
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:I11	Expression	=COUNTIF(B$4:B4,B4)>1	text	YES

 

[HappyWilliam]

Thanks for your response, Nope

I would like a formula to highlight duplicates for the ranges from B4:I11 ignoring first occurrence. Not single columns

 

[kevin9999]

And do you want it checked by going down columns first (i.e. B2:B11 then C2:C11) or across rows first (i.e B4:I4 then B5:I5)? Depending on which way you go, the answer would be different. For example, if you go columns first, then the 56 under Check C wouldn't be highlighted, whereas the 56 under Check D would be. If you go rows first, then these highlights would be reversed. Which way are you looking for?

 

[HappyWilliam]

thanks for offering solutions to my request, you are right it does not answer my question.

i would like a formula or vba code to work within the range B4:I11, individual columns is time consuming and would not solve the question

 

[kevin9999]

i would like a formula or vba code to work within the range B4:I11

That doesn't answer my question:

do you want it checked by going down columns first (i.e. B2:B11 then C2:C11) or across rows first (i.e B4:I4 then B5:I5)?

In other words, what do you mean by:

a formula or vba code to work within the range B4:I11

You need to tell the formula/VBA code how exactly you want it to "work within the range"

 

[HappyWilliam]

Thanks Kevin, okay lets try down columns first (i.e. B2:B11 then C2:C11)

 

[Peter_SSs]

Is this what you mean?

23 05 29.xlsm
	A	B	C	D	E	F	G	H	I
3		Check A	Check B	Check C	Check D	Check E	Check F	Check G	Check H
4		2	15	23	8	14	21	22	38
5		4	13	48	56	45	2	65	70
6		10	11	56	42	32	37	52	99
7		22	53	7	47	50	59	67	90
8		55.5	2	45	100	115	145	73	48
9		99	88	59	13	33	39	49	50
10		4	55.5	70	51	81	64	120	115
11		2	11	40	52	25	35	99	65
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B4:I11	Expression	=COUNTIF($A4:A$11,B4)+COUNTIF(B$4:B4,B4)>1	text	NO