Column Comparison with Font Color Change and Tally Help

Hello,

In need of some assistance for a side project I'm doing for a college football message board. Each year we do College Pick'ems - basically we provide a list of teams, a person chooses the winner, simple as that. I tally up the count each week, at the end of the season the person with the most correct picks wins a prize.

I thought this year I may experiment around with excel and let some of the functions, excel has to offer, take care of some of the work involved each week.

I've attached the worksheet for your viewing pleasure. Here is what I was aiming for. Cells A3 - A22 has the games for each week. Column's D through how many participate, contain the team name (Row 1) with their selections D3 - D22, E3 - E22, etc. Column B3 - B22 will contain the winner of each game from column A.

My goal was to compare the the person's selection in column D with the actual winner in column B. If correct, there would be a two part result...1) Change the font color of a correct pick within a person's selections GREEN. 2) Adding a point to the Total Correct Picks (D27).

If they made an incorrect pick 1) Change the font color of the incorrect pick to RED 2) Add 0 to the total correct picks.

My excel knowledge is limited to basic math functions and formatting. I'm not very knowledgable outside of that. I did some reading and saw a CountIf function, which may be able to compare the two columns and create a running total. But I wasn't too sure how to write out the code. I am clueless if there is an option to change font color based on a comparison.

Sorry for the long winded post and thanks in advance for any and all help.

Try sumproduct instead. =Sumproduct(--(D3:D24=$B$3:$B$24)) should work.
Changing color can be done with a simple formula of =D3=B3 in conditional formatting, then dragged down. Set the font color to green. For red, you'd want =AND(B3<>"",D3=B3).

Lastly, as a side note, it is much better to post the actual excel workbook here. It allows us to try out solutions and so helps us help you. For a simple issue like this, we can do without, but if future questions are more complicated, it'd help a lot.

Correction to formula for red: =AND(B3<>"",D3<>B3).

No, copy and paste special-> formats.

nm - I got it figured out