, Good afternoon.
As we do not know the layout of your file gets a bit more difficult to help.
You did not respond if any cell per member indicates which category it belongs to.
Since you have four different tables with the respective names for the four existing categories, perhaps a named range solves your doubt.
--> Members names of Category 1 -> Color Blue
Create a named range with A1:A50 named: Category1
--> Member name in the other area.
Conditional Formatting Menu -> Using Formula
= COUNTIF(Category1, G1)
Format for Font in BLUE.
Proceed in the same way with the other tables.
Tell us if this helped resolve the issue.
I hope it helps.
Belo Horizonte, Brasil