I run a fitness bootcamp and am trying to send out docs that show how many classes a member has attended. I have an Excel spreadsheet with two sheets:
1. showing the calendar. Each cell contains that date.
2. a sheet showing student name (col.a) and attendance date (col. b)
I have drop down box that will select a student. I'd like to then use a conditional formatting to color all dates of attendance by looking for the student's name, then pulling an array of all the attendance dates..then checking for the date.