thetank
Board Regular
- Joined
- Mar 17, 2005
- Messages
- 142
I am trying to keep track of the college bowl games and would like some help from excel.
I have about 30 people in the "pool". I have all the names in column A and each of their corresponding picks out to the right.
I would like to be able to type in the winner of each game at the top of the column and have excel highlight the winners.
I would also like to have excel put the names in order of most right to most wrong. I am sure this will have to be done with a macro, but I don't know the code well enough to figure it out.
I hope you can help. Thanks in advance.
Below is a small example:
If this were in excel, I would like the CSU in craigs row to be highlighted red and also the UT and CSU in Johns row.
SM Tol Cal Na
Brian C SM Tol Cal Na
Craig S SM Tol Cal CSU
John H UT Tol Cal CSU
_________________
I have about 30 people in the "pool". I have all the names in column A and each of their corresponding picks out to the right.
I would like to be able to type in the winner of each game at the top of the column and have excel highlight the winners.
I would also like to have excel put the names in order of most right to most wrong. I am sure this will have to be done with a macro, but I don't know the code well enough to figure it out.
I hope you can help. Thanks in advance.
Below is a small example:
If this were in excel, I would like the CSU in craigs row to be highlighted red and also the UT and CSU in Johns row.
SM Tol Cal Na
Brian C SM Tol Cal Na
Craig S SM Tol Cal CSU
John H UT Tol Cal CSU
_________________