Forum Discussion
javawn
Oct 27, 2023Copper Contributor
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?
- OliverScheurichGold Contributor
=INDEX($D$1:$F$1,MATCH(G2,D2:F2,0))
With this formula you can return the carrier column with the lowest rate.
- javawnCopper Contributor