I am trying to make a formula that gives me the lowest price at a named cell.
eg. E7,L7,S7,Z7 are different prices, I want the lowest price to be at AD.

The other issue I have is that each one represents a different colour.
eg. E7 -green, L7 -purple, S7 -orange, Z7 -pink.
I want the lowest price to be at cell AD, but also colour coded.
--
skyjewels