Highlight Value Changes Across Two Columns

[HMilne]

I have a spread sheet that in Column A lists all the part numbers we purchase and Column B lists the Vendor we bought that part from. I am looking for a way to highlight any multiple vendors that might have been used for each part number.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff v2.xlsm
	A	B
1	County	District
2	Buckinghamshire	Wycombe
3	Cornwall	Cornwall
4	County Durham	County Durham
5	Cumbria	Eden
6	Cumbria	Eden
7	Derbyshire	Amber Valley
8	Derbyshire	Derbyshire Dales
9	Devon	Teignbridge
10	Devon	Torridge
11	Dorset	North Dorset
12	Gloucestershire	Cotswold
13	Greater Manchester	Oldham
14	Greater Manchester	Oldham
15	Greater Manchester	Oldham
16	Greater Manchester	Stockport
17	Lancashire	Blackburn with Darwen
18	Lancashire	Pendle
19	Lancashire	Pendle
20	North Yorkshire	Hambleton
21	Oxfordshire	Cherwell
22	Shropshire	Shropshire
23	Staffordshire	Cannock Chase
24	Staffordshire	Stoke-on-Trent
25	Staffordshire	Stoke-on-Trent
26	Surrey	Waverley
27	West Midlands	Birmingham
28	West Yorkshire	Bradford
29	West Yorkshire	Kirklees
30	West Yorkshire	Kirklees
31
32
33
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:B38	Expression	=COUNTIFS($A$2:$A$100,$A2,$B$2:$B$100,$B2)>1	text	NO

 

[HMilne]

No that doesn't, it is highlighting parts that have no change in vendor.

 

[Fluff]

In that case I may have misunderstood you request, can you please explain again & show expected results.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[HMilne]

My company does not allow us to install anything not pre-added by IT.

What I am hopping for something that can look at each part number in column A and any change in vendor for that individual part number be highlighted:

InvtID	VendName
GreenCable10	Green Star
GreenCable10	Accu Cable
GreenCable10	Green Star
GreenCable10	Accu Cable
GreenCable10	Accu Cable
Cat-5 Red	Accu Cable
Cat-5 Red	Green Star
Cat-5 Red	Accu Cable
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.
B3445	Blue Star, Inc.

 

[Fluff]

Ok, how about

=COUNTIFS($A$2:$A$100,A2,$B$2:$B$100,">"&B2)