Keep Track of Bowl Games

[thetank]

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

 

[anthonya2369]

I wonder if just using Conditional Formatting and you input the winner as Green Background, if loser, then Red Background. Then have the total to the far right of All Correct Picks and then just do a Descending Sort and no macro needed.

 

[thetank]

I wanted to make it easy for others to check. You know, just type in the winner and hit enter and let excel do its thang.

 

[Pekkavee]

You can do it with Conditional formatting like this.
Obs. $-sign in formatting.

Työkirja1
	A	B	C	D	E	F
1			SM	Tol	Cal	Na
2	Brian	C	SM	Tol	Cal	Na
3	Craig	S	SM	Tol	Cal	CSU
4	John	H	UT	Tol	Cal	CSU
5
6	Conditional formatting in C2
7	Cell is not egual to =C$1, then select red color
8	Then copy formatting with format painter
9	to all cells
10
Taul1

You can put an extra CF condition in cell C2 like

Cell is egual to =C$1, then select green color, so winners will be green cells.

Regards
Pekka

 

[Brian from Maui]

Talk about cross posting....

http://www.wopr.com/cgi-bin/w3t/sho...=544934&page=0&view=collapsed&sb=5&o=0&fpart=

http://www.theofficeexperts.com/forum/showthread.php?t=5458