Abe : First sort by item and price. There should be 7 rows for each item.
Highlight the first seven rows wit a different color. Then copy these 7 row.
then highlight the rest of the worksheet. Use Paste Special and Paste only
the Format. the same 7 colors will repeat on every row. You can then sort
again by vendor.

"AbeAbeAbe" wrote:

I have a worksheet which shows many rows of data from 7 vendors. Each of the
7 vendors are listed in columns. I want to sort the values of each cell in
each row. I want to see the highest value in one color proceeding in
different colors as the value decrease. For example in row 1, D1 may be
highest value thus is colored blue and A1 may be the lowest so it would be
red. On row 2 E2 might be the
highest thus would be colored blue, A2 might be next and is colored orange,
while B2 is the lowest and ends up being red. 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