Colourful Message Boxes When They Return Search Results.

I have created this macro to search for friendly and enemy clans in a game. (There are hundreds, but I have only put 4 in for testing purposes).

The macro works fine, but I'd like the message boxes to be coloured, red for enemy green for friendly for instance.

I have absolutely no idea how to go about it. Can anyone help?

Briefly the macro is in search sheet, and data is in hidden sheet called clans. I have done that so that it can't be edited by users. I unlock and relock within the code.

I protected the search sheet, but can't remember if I unlocked it - so if you need to log in the password in BBC. This is temporary, I will do something more permanent when finished.

Thanks

Kev