| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting 4 rows of data and changing the text of the highest value.
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| sorting rows without changing order of my values! | Excel Discussion (Misc queries) | |||
| How torecord the highest value in a set of constantly changing num | Excel Worksheet Functions | |||
| sorting a constantly changing set of rows in VBA | Excel Discussion (Misc queries) | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Threaded Mode
