I have a conditional format in place on sheet1 that highlights the entire row
(data in Col A - Col L) if there in text input in the cell of Col D. My task
now is to go to other tabs lookup the person's name (Col B, sheet2) find a
match on sheet1 and if that name is highlighted on sheet1, automatically
highlight the row of data on sheet2. Help?!?!?