I am relatively new to conditional formatting in Excel although I understand the basics. I have a worksheet containing many columns with each column containing a HEADER and a list of terms below it. I want to set up the worksheet so another user can click on a term in a list of unique terms and IF that term is listed in any column, the cell is shaded. Here is a small example:
| Affinito | Ahlbrandt | Allison |
| Endowed | Academic Performance | Academic Performance |
| Female | Endowed | Endowed |
| Katz | Fellowship | Fellowship |
| Students | Fulltime | Fulltime |
| | Katz | Katz |
| | Need | Need |
| | PhD | PhD |
| | Students | Students |
TERM LIST
Students
Katz
PhD
Need
Female
Academic Performance
If someone clicks on the word "PhD" in the list, I want the cells containing PhD in the last 2 columns to be highlighted in yellow.
If I can get that to work, then my next question is, can I make it so that if I click on a SECOND word in the list, the original formatting remains and the new terms are also highlighted maybe in a different color...in a cumulative fashion. Or if someone has unclicked a term, the highlighting would be removed in the columns.
Thanks for any help you can give.
