An opportunity card with overdue tasks should be colored “red” so that users can see at a glance which opportunities need to be addressed first (e.g. Pipedrive)

A more flexible way would be to allow color codes based on opportunity tags. That way, it would be enough to add tags with workflows, according to a free scenario.