Neutron stars and the transition to color superconducting quark matter