Forum Discussion

javawn's avatar
javawn
Copper Contributor
Oct 27, 2023

EXCEL conditional formatting

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? 

 

  • javawn 

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

     

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

Resources