Sir,
Highlight minimum price between vendor A & C.
Note:- position of the vendor column can not change
Enclose example file for your reference
Highlight minimum price between vendor A & C.
Note:- position of the vendor column can not change
Enclose example file for your reference
Vendor - A | Vendor - B | Vendor - C | |
Item | Price | Price | Price |
Apple | 100 | 80 | 90 |
Orange | 20 | 50 | 30 |
Grape | 120 | 100 | 110 |
Banana | 40 | 70 | 50 |
Guava | 80 | 90 | 100 |
Jackfruit | 200 | 160 | 170 |