I'm tracking illnesses at my school for frequency & potential outbreaks. I have column E as "Illness Type" and column G as "Teacher." If any teacher has 3+ cases of the same sickness type in their class, I'd like the cells to highlight (bonus points if it highlights the entire rows of the relevant cases). I don't want the cells to highlight just if "GI" (etc.) appears in column E 3+ times, nor if teacher "Jones" is listed 3+ times, but rather if there are 3+ cases of GI illness specifically within Jones' class. Can anyone help? I've spent hours researching online but my Excel skills are so basic, I just don't have the skill set. Maybe it's not even possible? Thanks in advance for any help.