I have a worksheet which shows many rows of data from 7 vendors. Each of the
7 vendors are listed in columns. I need to sort through this data. What I
would like to do is to have the prices from each vendor in row 1 compared and
make the highest value in row 1 blue, the second highest green, 3rd blue,
ect... Then repeat this process for all of the data rows. This way I can
get a quick visual observation of the vendor which has to most items in the
lowest or highest category.
--

--
Thanks for the help!