Read the release notes and user comments in the workshop.

you have to double-click and then it turns green

Unfortunately, you can not use the red/green indicator in the Mod Manager to know whether a mod will work or not. If a mod author includes a line in the manifest to indicate that the mod is intended for the game version you're using, then you get green light and if the version doesn't match you get red. However, if they do not include this version information, then you also get green as the game assumes the mod is compatible.

*** In no way does the game actually know if the mod will work or be compatible in conjunction with other mods. ***