Compare adjacent cells in one column and if they are the same highlight them

[Francois Bekker]

Please see an extraction out of my data set. I would like to highlight the adjacent cells (in column:Service_Week) that are the same (See example below - in bold). Is there a formula that I can use in conditional formatting to do this? Please help.

Trap_ID	Service_Date	Service_Day	Service_Week	Days_Active	Wild_Moth_Count	WM/T/D	Sterile_Moth_Count	SM/T/D	Infestation	Crop_Sanitation
Ajlp 1	2009/08/26	Wednesday	35		4		0		0	2
Ajlp 1	2009/09/03	Thursday	36	8	5		0		0	2
Ajlp 1	2009/09/10	Thursday	37	7	4		0		0	2
Ajlp 1	2009/09/16	Wednesday	38	6	0		0		0	3
Ajlp 1	2009/09/23	Wednesday	39	7	8		28		0	2
Ajlp 1	2009/09/30	Wednesday	40	7	7		0		0	3
Ajlp 1	2009/10/07	Wednesday	41	7	0		22		0	3
Ajlp 1	2009/10/14	Wednesday	42	7	1		0		0	3
Ajlp 1	2009/10/21	Wednesday	43	7	2		5		0	3
Ajlp 1	2009/10/28	Wednesday	44	7	0		54		0	3
Ajlp 1	2009/11/04	Wednesday	45	7	0		5		0	3
Ajlp 1	2009/11/18	Wednesday	47	14	1		3		0	3
Ajlp 1	2009/11/25	Wednesday	48	7	0		28		0	3
Ajlp 1	2009/12/03	Thursday	49	8	0		18		0	3
Ajlp 1	2009/12/09	Wednesday	50	6	0		30		0	3
Ajlp 1	2009/12/16	Wednesday	51	7	0		64		0	3
Ajlp 1	2009/12/23	Wednesday	52	7	1		22		0	3
Ajlp 1	2009/12/30	Wednesday	53	7	1		24		0	3
Ajlp 1	2010/01/06	Wednesday	1	7	0		41		0	3
Ajlp 1	2010/01/13	Wednesday	2	7	0		5		0	3
Ajlp 1	2010/01/20	Wednesday	3	7	0		5		0	3
Ajlp 1	2010/02/01	Monday	5	12	0		11		0	3
Ajlp 1	2010/02/08	Monday	6	7	0		9		0	3
Ajlp 1	2010/02/11	Thursday	6	3	0		3		0	3
Ajlp 1	2010/02/17	Wednesday	7	6	0		47		0	3
Ajlp 1	2010/02/24	Wednesday	8	7	0		12		0	3
Ajlp 1	2010/03/03	Wednesday	9	7	0		85		0	3

<tbody>
</tbody>

 

[Francois Bekker]

Thanks I found the solution - thanks

=OR(OFFSET(D2,-1,)=D2,OFFSET(D2,1,)=D2)

 

[mick0005]

Thanks I found the solution - thanks

=OR(OFFSET(D2,-1,)=D2,OFFSET(D2,1,)=D2)

Clever girl. I like it.