Labour councillors will now no longer be in coalition with the Greens in areas including Sheffield, Warwick and Lewes.