How can I sort data and have the highest value red, 2nd blue, ect

A

AbeAbeAbe

How can I sort data in each row and have the highest value red, the 2nd
highest value blue, 3rd yellow, ect....

For example. I have 30 rows of data with each row containing 10 collumns of
numbers. For each line I would like to have excel sort the values in that
row and change the color of the highest value to blue, second highest to red,
ect.. After this has been preformed, I will be able to look at all of the
values and see a trend which collom is consistantly the highest simply by the
colors of the data.

Please email any ideas to:

(e-mail address removed)

Thanks!!!
 
E

excelent

in this eksamble : select A1:J1
in condit.format insert:

=A1=LARGE($A1:$J1,1) -first choice blue
=A1=LARGE($A1:$J1,2) -sekond red
=A1=LARGE($A1:$J1,3) -3 yellow

to copy format to all 30 rows u have to copy
formatcopy dosent work here
otherwise u have to manually do it for all 30 row 1 at a time



"AbeAbeAbe" skrev:
 
A

AbeAbeAbe

I am sorry, but where do I enter this formula? Please be detailed. Do I
highlight all of the data in the rows that I want this formula to apply to,
then where do I enter this formula? What feature do I use. Do I enter all
three lines and how do I enter the colors to assign to the various values?

Thanks!
 
E

excelent

First select first row (all columns in that row)

Then click Menu: Format>Conditional Format
condition1 choose Formula is
then input =A1=LARGE($A1:$J1,1) in box to the right
then click on Formatbutton and choose color (blue)
click Add
then input =A1=LARGE($A1:$J1,2) in box to the right
then click on Formatbutton and choose color (red)
click Add
then input =A1=LARGE($A1:$J1,3) in box to the right
then click on Formatbutton and choose color (yellow)
click OK

select row again (all columns in that row u want)
and copy down 30? rows down
or insert formula manually if u dont want ur data erased
with a copy of row 1


"AbeAbeAbe" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top