How to highlight the lowest value in a row

We have a board used for comparing prices of products that we can get from multiple suppliers. We wanted to have the lowest value of a row highlighted. I could only find a way to highlight values based on a specific value.

I asked our programmer to help us out and came up with the following formula:

SWITCH(
	MIN(
      {Supplier1},
      {Supplier2},
      {Supplier3},
      {Supplier4},
      {Supplier5}
    ),
    {Supplier1}, "Supplier1",
    {Supplier2}, "Supplier2", 
    {Supplier3}, "Supplier3",
    {Supplier4}, "Supplier4",
    {Supplier5}, "Supplier5",
    "-"
)

This shows a column with the name of the supplier that has the cheapest price. It’s not completely what we wanted, but I’m happy with the results and I hope someone else will find this useful!

1 Like

@binsento

I like the concept!

Thanks for sharing!