Use countif

=IF(COUNTIF(B$4:B$24,B4)1,TRUE,FALSE)

Notice the S. Copy this down to al cells between B4 to B24.

"Matlock" wrote:

Awesome, I got the B4:B23 to be highlighted if H4:H23 have the same name.

Now, how do we get B4:B23 to highlight itself if the same employee is listed
twice within B4:B23?