EXCEL conditional formatting

[javawn]

Hello,

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

[#2]

@javawn 

=INDEX($D$1:$F$1,MATCH(G2,D2:F2,0))

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

[#3]

@OliverScheurich This is Awesome and so very helpful! 

I appreciate you!

Best Regards,

Javawn