Flag/highlight data based on specific data within the cells

[asivaraman]

Hi,

I am looking for a VBA code that can flag/highlight rows based on certain criterias.
There are 3 distinctive part numbers in the below table, with multiple Distributor, price breaks and pricing.

Each "price break" column is ranked based on the price. In this case, we keep EDAC as the benchmark.
If you look at the Price break 25 (red font) you will see Mouser Electronics has a price greater than EDAC.
My request is to highlight/flag the part numbers (within Price Breaks range) that have Ditributors Priced above EDAC.

So the output will have to highlight Mouser electronics column under the 25 Price break(red font) as well as the 100 Price break (blue font).
Sometimes there might be 2 or more Distributors prices higher than EDACs.
I hope the problem was explained properly.


[TABLE="width: 649"]
<tbody>[TR]
[TD]
Mkt Price Rank
[/TD]
[TD]Part Number
[/TD]
[TD]Distributor
[/TD]
[TD]Stock
[/TD]
[TD]Price Break
[/TD]
[TD]Price
[/TD]
[TD]Currency
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Verical
[/TD]
[TD]97
[/TD]
[TD]1
[/TD]
[TD]2.6694
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]1
[/TD]
[TD]3.43
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Master Electronics
[/TD]
[TD]100
[/TD]
[TD]1
[/TD]
[TD]4.22
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]100
[/TD]
[TD]1
[/TD]
[TD]4.22
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Electro Sonic
[/TD]
[TD]100
[/TD]
[TD]1
[/TD]
[TD]4.3466
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]1
[/TD]
[TD]6.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]10
[/TD]
[TD]3.288
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]10
[/TD]
[TD]6.68
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]25
[/TD]
[TD]3.014
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Master Electronics
[/TD]
[TD]100
[/TD]
[TD]25
[/TD]
[TD]3.95
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]100
[/TD]
[TD]25
[/TD]
[TD]3.95
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Electro Sonic
[/TD]
[TD]100
[/TD]
[TD]25
[/TD]
[TD]4.0685
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]4.5
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-500-202
[/TD]
[TD]EDAC
[/TD]
[TD]
[/TD]
[TD]25
[/TD]
[TD]5.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]25
[/TD]
[TD]6.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]50
[/TD]
[TD]2.877
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]4.01
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]50
[/TD]
[TD]5.81
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Master Electronics
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]2.53
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]2.53
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Electro Sonic
[/TD]
[TD]100
[/TD]
[TD]100
[/TD]
[TD]2.6059
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]100
[/TD]
[TD]2.74
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-500-202
[/TD]
[TD]EDAC
[/TD]
[TD]
[/TD]
[TD]100
[/TD]
[TD]3.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]100
[/TD]
[TD]5.52
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]125
[/TD]
[TD]3.9
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Master Electronics
[/TD]
[TD]100
[/TD]
[TD]250
[/TD]
[TD]2.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]100
[/TD]
[TD]250
[/TD]
[TD]2.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Electro Sonic
[/TD]
[TD]100
[/TD]
[TD]250
[/TD]
[TD]2.163
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]250
[/TD]
[TD]2.39752
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-500-202
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]250
[/TD]
[TD]3.03
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]3.83
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]250
[/TD]
[TD]4.94
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]500
[/TD]
[TD]2.329
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]500
[/TD]
[TD]2.77
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]500
[/TD]
[TD]4.65
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Digi-Key
[/TD]
[TD]79
[/TD]
[TD]1000
[/TD]
[TD]1.9865
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-202
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]1000
[/TD]
[TD]2.29
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]1000
[/TD]
[TD]4.07
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-202
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]31
[/TD]
[TD]2500
[/TD]
[TD]3.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Master Electronics
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]4.22
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]4.22
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]1
[/TD]
[TD]6.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]10
[/TD]
[TD]6.68
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Master Electronics
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]3.95
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]3.95
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]25
[/TD]
[TD]5.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]6.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Digi-Key
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]6.426
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]5.81
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Master Electronics
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]2.53
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]2.53
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]100
[/TD]
[TD]3.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]5.52
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Master Electronics
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]2.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]2.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]250
[/TD]
[TD]3.03
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]4.94
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]500
[/TD]
[TD]2.77
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]500
[/TD]
[TD]4.65
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]1000
[/TD]
[TD]2.29
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]1000
[/TD]
[TD]4.07
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-500-204
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]0
[/TD]
[TD]2500
[/TD]
[TD]3.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]1
[/TD]
[TD]3.43
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Master Electronics
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]6.8
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]6.8
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]1
[/TD]
[TD]6.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Electro Sonic
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]7.004
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[TD]4.78
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]10
[/TD]
[TD]3.288
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]10
[/TD]
[TD]6.68
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]25
[/TD]
[TD]3.014
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]25
[/TD]
[TD]4.2
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]25
[/TD]
[TD]5.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Master Electronics
[/TD]
[TD]1
[/TD]
[TD]25
[/TD]
[TD]6.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]25
[/TD]
[TD]6.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]1
[/TD]
[TD]25
[/TD]
[TD]6.1
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Electro Sonic
[/TD]
[TD]1
[/TD]
[TD]25
[/TD]
[TD]6.283
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]50
[/TD]
[TD]2.877
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]50
[/TD]
[TD]4.08
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Master Electronics
[/TD]
[TD]1
[/TD]
[TD]50
[/TD]
[TD]5.8
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]1
[/TD]
[TD]50
[/TD]
[TD]5.8
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]50
[/TD]
[TD]5.81
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Electro Sonic
[/TD]
[TD]1
[/TD]
[TD]50
[/TD]
[TD]5.974
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]100
[/TD]
[TD]2.74
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]100
[/TD]
[TD]3.56
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]100
[/TD]
[TD]3.97
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Master Electronics
[/TD]
[TD]1
[/TD]
[TD]100
[/TD]
[TD]5.52
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]100
[/TD]
[TD]5.52
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Onlinecomponents.com
[/TD]
[TD]1
[/TD]
[TD]100
[/TD]
[TD]5.52
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Electro Sonic
[/TD]
[TD]1
[/TD]
[TD]100
[/TD]
[TD]5.6856
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]250
[/TD]
[TD]2.39752
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]250
[/TD]
[TD]3.03
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Future Electronics
[/TD]
[TD]0
[/TD]
[TD]250
[/TD]
[TD]3.83
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]250
[/TD]
[TD]4.94
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]500
[/TD]
[TD]2.329
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]500
[/TD]
[TD]2.77
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]500
[/TD]
[TD]4.65
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Digi-Key
[/TD]
[TD]566
[/TD]
[TD]1000
[/TD]
[TD]1.9865
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]305-012-520-201
[/TD]
[TD]EDAC
[/TD]
[TD][/TD]
[TD]1000
[/TD]
[TD]2.29
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]1000
[/TD]
[TD]4.07
[/TD]
[TD]USD
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]305-012-520-201
[/TD]
[TD]Mouser Electronics
[/TD]
[TD]125
[/TD]
[TD]2500
[/TD]
[TD]3.97
[/TD]
[TD]USD
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Hi & welcome to MrExcel.
Is there any reason you need VBA, as this can be done very easily with conditional formatting.

 

[asivaraman]

Hello, thanks for the response. I did look into it. Having a mindblock. Could you please enlighten me?
THanks!

 

[Fluff]

Select the cells A2:G102 (for your test data)
In CF New rule > Use a formula >
=$A2>INDEX($A$2:$A$102,MATCH($B2&"|"&$E2&"|Edac",INDEX($B$2:$B$102&"|"&$E$2:$E$102&"|"&$C$2:$C$102,0),0))
Select your format > OK

Change the range lengths in the formula to match the applies to range

 

[asivaraman]

Thank you for the help. It works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback