Hi Braydon16,

These three formula are giving the occurrence number of B2 in range "Result_List" and if the occurrence is 1 or 2 or 3 the logic becomes true and conditional formatting applies.. check on this angel.. and if still face issues, upload the sample file. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>