I run a confidence football pool that has over 60 people. I already use vba to add up the correct number of picks and the totals as long as the correct picks are highlighted with yellow fill.
I am looking for a solution to highlighting every single pick by hand. I was thinking of an if then statement so that is GB is highlighted in 1 cell it will highlight all GB's in the entire range and the cell to the right of GB.
the sheet is set up so that the team selection is in a2 and the confidence # is in a3. I would want both cells highlighted yellow if a winning team cell is highlighted.
Any help would be greatly appreciated. If further clarification is needed please let me know.
Thanks
Andy
I am looking for a solution to highlighting every single pick by hand. I was thinking of an if then statement so that is GB is highlighted in 1 cell it will highlight all GB's in the entire range and the cell to the right of GB.
the sheet is set up so that the team selection is in a2 and the confidence # is in a3. I would want both cells highlighted yellow if a winning team cell is highlighted.
Any help would be greatly appreciated. If further clarification is needed please let me know.
Thanks
Andy
