Category1 Category2 Category3 ..... more columns
John Doe AM A,CA SA
Mary Kole E E E ...... more columns
I would like to shade the entire summary cells for Mark Kole yellow. If not E, do not shade. AM, TA,CA SA, E are the the summary field values in this example.
If value is E,