A
AbeAbeAbe
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.
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.