Rizon
10-14-2011, 11:39 AM
So I was curious about my SP league averages on ratings, compare my players against others, etc. I exported out all rosters and put them into Excel.
I created a different tab for every position (QB, RB, FB, WR, TE, etc).
Taking QBs for example ... what I want to do is sort each column of data for the QBs, and highlight the top 10 in each of the passing categories. It looks like conditional formatting can do this, but it only seems to work on one column at a time ... and there are a LOT of columns, obviously. I could even filter/sort them one by one and make the formatting myself but that would take a lot of time.
So, what do you guys do? Is there an easier way?
Note: I have no experience in Access, sadly.
I created a different tab for every position (QB, RB, FB, WR, TE, etc).
Taking QBs for example ... what I want to do is sort each column of data for the QBs, and highlight the top 10 in each of the passing categories. It looks like conditional formatting can do this, but it only seems to work on one column at a time ... and there are a LOT of columns, obviously. I could even filter/sort them one by one and make the formatting myself but that would take a lot of time.
So, what do you guys do? Is there an easier way?
Note: I have no experience in Access, sadly.