Highlighting Unique prices with a 2 column list.

[trekker1218]

Hello,
I have an item price list by item number in column A and various prices for item in Column B. I need to highlight all the different prices for each item number. see sample below.
The RMCUST is customer ID# Customers get unique pricing based on buying power they have.
I want to highlight all the same prices with same color then fill down on ALL customers and item numbers

Customer #	Item #	Price
0020299	0135-0138	$ 2.29
0020301	0135-0138	$ 2.69
0020303	0135-0138	$ 2.29
0020305	0135-0138	$ 3.29
0020306	0135-0138	$ 2.29
0020307	0135-0138	$ 2.19
0003984	0369SRAW	$ 169.13
0017119	0369SRAW	$ 169.13
0019670	0369SRAW	$ 169.13
0019674	0369SRAW	$ 149.13
0020263	0369SRAW	$ 169.13
0020265	0369SRAW	$ 269.13
0020266	0369SRAW	$ 169.13
0020267	0369SRAW	$ 169.13
0020270	0369SRAW	$269.13

 

[Toadstool]

Hi Trekker1218,

I'm not sure I've understood correctly. Are these the ones you'd expect to be highlit?

Trekker1218.xlsx
	A	B	C
1	Customer #	Item #	Price
2	20299	0135-0138	$2.29
3	20301	0135-0138	$2.69
4	20303	0135-0138	$2.29
5	20305	0135-0138	$3.29
6	20306	0135-0138	$2.29
7	20307	0135-0138	$2.19
8	3984	0369SRAW	$169.13
9	17119	0369SRAW	$169.13
10	19670	0369SRAW	$169.13
11	19674	0369SRAW	$149.13
12	20263	0369SRAW	$169.13
13	20265	0369SRAW	$269.13
14	20266	0369SRAW	$169.13
15	20267	0369SRAW	$169.13
16	20270	0369SRAW	$269.13
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C99999	Expression	=COUNTIFS($C$2:$C$99999,$C2,$B$2:$B$99999,$B2)=1	text	NO

 

[trekker1218]

Hi Trekker1218,

I'm not sure I've understood correctly. Are these the ones you'd expect to be highlit?

Trekker1218.xlsx
	A	B	C
1	Customer #	Item #	Price
2	20299	0135-0138	$2.29
3	20301	0135-0138	$2.69
4	20303	0135-0138	$2.29
5	20305	0135-0138	$3.29
6	20306	0135-0138	$2.29
7	20307	0135-0138	$2.19
8	3984	0369SRAW	$169.13
9	17119	0369SRAW	$169.13
10	19670	0369SRAW	$169.13
11	19674	0369SRAW	$149.13
12	20263	0369SRAW	$169.13
13	20265	0369SRAW	$269.13
14	20266	0369SRAW	$169.13
15	20267	0369SRAW	$169.13
16	20270	0369SRAW	$269.13
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C99999	Expression	=COUNTIFS($C$2:$C$99999,$C2,$B$2:$B$99999,$B2)=1	text	NO

Yes.
i need to hilight all the different prices by color if possible.
so item# 0135-0138 with price of 2.29 would all be yellow
and price of 2.69 could be green and so on.

then repeat for each item number

 

[Toadstool]

Conditional Formatting using a formula only allows one format per formula. I think you'd need VBA to set various colors.

 

[trekker1218]

ok. I tried the conditional rule yo uprovided above and it only changed the first row.

 

[Toadstool]

This assumed your data started at A2.
Don't forget to set the Conditional format on all rows (e.g. A2:C99999)
It's important to use the correct relative/absolute addressing

=COUNTIFS($C$2:$C$99999,$C2,$B$2:$B$99999,$B2)=1