JieJenn,

Thanks so much - it works perfect!

Just one more question - I realized that some of cells actually have a few different colors and using your formula - they're all changed to black color.
In the VBA code you wrote for me, is it possible to add some sort of if function, such as changing only colors in 160, 184, 214 (blue font color I'm using).
Thanks so much!