For the range
C2:Z100 we apply the following formula to find duplicate students' enrollments using conditional formatting:
=COUNTIFS($C:$C,C2 , $D:$D,D2)>1
C is the
last name and
D is the
first name e.g.
Unfortunately, we only get single duplicate cells in column
But... We want to have the entire row highlighted.
We have tried different variations and suggestions from the site as here and here or here (as well as many others). Nothing seems to work for the entire row. Also tried with
=AND (COUNTIFS($C:$C,C2 , $D:$D, D2)>1),
On the other hand this formula
=$B2="G" highlights an entire row
What do we do wrong?
This is a link to a demo sheet as requested