I have the attached sheet (this is just one page of many in the workbook) and I have been trying to use CF to highlight any data that does not match (totaly wrong or mispelled) for easier identification. The problem came up that the CF would not act right. So, I am turning to you guys for some possible help in switching to VBA to accomplish my task. Basically, the teams in B2:C23 are playing each other. The selections (all the pick sheets that are located G4:AJ441) need to match the teams playing or they will not get points. So, is there a way to get the VBA to scour the sheet and find errors between Team 1 & Team 2 and the individual pick sheets?
I hope the question was clear here.
Thanks in advance for the assistance.
Chris
Bookmarks