EXCEL conditional formatting

Copper Contributor



can anyone offer help on how I get column G "LOWEST" to reflect which color or Carrier column it pull the lowest rate from? 


DOMESTIC TRUCKING BID TRENTWOOD - KAISER - Excel 10_27_2023 10_58_31 AM.png

2 Replies




With this formula you can return the carrier column with the lowest rate.

carrier column with lowest rate.png

@OliverScheurich This is Awesome and so very helpful! 


I appreciate you!


Best Regards,