I have a workbook that has multiple tabs of student lists. One is a master list and two others are noncompliance lists. Sheet 1 is set to pull the student's name from the master list into column C when the student ID is entered in column A using =IFERROR(VLOOKUP(A2,'Student ID''S'!$A$2:$D$898,2,0),""). I also need that entry to trigger the row going red for one of the noncompliance lists or blue for the other (students will not appear on both lists). What is the best way to accomplish this?
Thanks!
Thanks!