Formula that check and give me results like "green(ok", "red(not ok)"

Hello all!
i need your pro help

I need to have a formula that check and give me results like "green(ok", "red(not ok)".
Let me explain:

I have a report with columns like username, name, surname, office, groups.
Every user has a lot of raw because every raw give me a particolar group where the user is. So for example:

USERNAME NAME SURNAME OFFICE GROUP
123456 jon doe nyc lawyer
123456 jon doe nyc legal
123456 jon doe nyc smartwork
123456 jon doe nyc keys
etc etc etc

Well, i need to check for every username(so mutiples raws for each one) if the user has a list of "groups". If yes is also possible to color the username(each row) with green or write somewhere something like "pass"?

Thanks to all