Highlight Cell of Minimum Value

[sambit]

Sir,
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

 

[bosco_yip]

Try,

select D5:F10 >>

• Conditional Formatting
• New rule...
• Use a formula....
• In the rule box enter : =OR(RIGHT(D$3)="A",RIGHT(D$3)="C")*(D5=MIN($D5,$F5))
• Choose format color
• Finish

 

[sambit]

Bosco_yip Sir,
Thank you very much.