I would like to highlight rows in Excel 2003 based on the entry in a column
which happens to be a student's name. I would like to be able to have excel
check a list of names automatically and highlight all the rows that pertain
to that student so I don't have to type in each name in the conditional
formatting box, which I understand is limited to 3 criteria.

I know nothing about VBA or any other kind of programming. Is this possible?