Highlight duplicate groupings

[jaugent27]

How do I highlight rows with unique duplicates? I have a report that lists estimates. Each row lists a separate sku/line item to the estimate with each line having the same estimate number. I want to be able to highlight the cells in either alternating colors or draw a border around the grouping of similar estimate numbers. So for each of the groupings in column A that are duplicates, all those rows would be highlighted a specific color say gray. Then then next grouping would be another color, perhaps just blank or white, then the third grouping would be gray again. Just something to easily show the groupings. Any suggestions? Thanks!

Estimate #	Date	Customer	Item	Price
1​	10/31/22​	Bill's Company	14503​	$10​
1​	10/31/22​	Bill's Company	14505​	$15​
1​	10/31/22​	Bill's Company	14506​	$9​
2​	11/2/22​	Tedco	15574​	$12​
2​	11/2/22​	Tedco	15573​	$11​
2​	11/2/22​	Tedco	15583​	$15​
2​	11/2/22​	Tedco	14576​	$9​
3​	11/5/22​	ABC Co	15547​	$12​
3​	11/5/22​	ABC Co	15579​	$8​
4​	11/6/22​	Fred Inc	19476​	$15​
5​	11/7/22​	Jerry's Sales	19756​	$9​
5​	11/7/22​	Jerry's Sales	19856​	$12​
5​	11/7/22​	Jerry's Sales	19854​	$15​

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[jaugent27]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Done, thanks.

 

[Fluff]

Thanks for that
How about

Fluff.xlsm
	A	B	C	D	E
1	Estimate #	Date	Customer	Item	Price
2	1	31/10/2022	Bill's Company	14503	£10
3	1	31/10/2022	Bill's Company	14505	£15
4	1	31/10/2022	Bill's Company	14506	£9
5	2	02/11/2022	Tedco	15574	£12
6	2	02/11/2022	Tedco	15573	£11
7	2	02/11/2022	Tedco	15583	£15
8	2	02/11/2022	Tedco	14576	£9
9	3	05/11/2022	ABC Co	15547	£12
10	3	05/11/2022	ABC Co	15579	£8
11	4	06/11/2022	Fred Inc	19476	£15
12	5	07/11/2022	Jerry's Sales	19756	£9
13	5	07/11/2022	Jerry's Sales	19856	£12
14	5	07/11/2022	Jerry's Sales	19854	£15
15
16
17
Data

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E20	Expression	=ISODD(MATCH($A2,UNIQUE($A$2:$A$100),0))	text	NO