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:

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:



Thanks!!!

--
Thanks for the help