Possible change colour from cells with same value in next row

[jellevansoelen]

Hello Ex(cel)perts,

I hope you can help me with the following issue.
We have large excel files with ascending numbers.

textexport-perjaar.xlsx
	B
1	aktenummer
2	1
3	2
4	3
5	4
6	5
7	6
8	7
9	8
10	9
11	10
12	11
13	12
14	13
15	14
16	15
17	16
18	16
19	17
20	18
21	19
22	20
23	21
24	1
25	2
26	3
27	4
28	5
29	6
30	7
31	8
Blad2

If you can see is on row number 17 and 18 the same or double number, namely 16.

I hope with conditional logic that it's possible to colour this double numbers if these are under each other.
With conditional logic on double numbers is not what I want, because the number 16 occurs very often.
Important for me when the same (double) number is under each other.

This should be the result:

textexport-perjaar.xlsx
	B
14	13
15	14
16	15
17	16
18	16
19	17
20	18
21	19
Blad2

Tnkyou,
Bye,
Jelle

 

[6StringJazzer]

Highlight the column starting in row 2, down to the maximum row where you might possibly have data.
Go to Conditional Formatting and add this rule using a formula:

=OR(B2=B3,B2=B1)

 

[jellevansoelen]

I must be making a mistake.

am I doing it right this way?

I don't get the desired result

 

[6StringJazzer]

What is the Applies To range you are using?

 

[Fluff]

Do you normally use English language functions, or Dutch ones?

 

[6StringJazzer]

You may have to use the Dutch word for "OR". I have no experience with non-English versions.

 

[Fluff]

If you do use Dutch then it would be OF rather than OR

 

[jellevansoelen]

Tnx, that works!
You're hero's.

 

[Fluff]

Glad we could help & thanks for the feedback.