Color Noise can be removed with the Lightness Channel in Lab Mode and some other tweaks in Photoshop.
This is a photo of my daughter taken with a mobile phone camera which has a lot of noise and a color cast.
The same image after working in Photoshop. You can do it too. The tutorial is here
Other Photoshop tutorials are here
