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:

    {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


I like the concept!

Thanks for sharing!