In Excel, how do I apply different colors to texts and numbers automatically?

I guess this must help you





http://www.exceltip.com/st/Color_numbers鈥?/a>





So you might want to first select all cells in Excel an then format it to some color that you want text to appear in.





Next you do this steps for selecting any of the colors for numbers.





Example: [BLUE] #,##0 ;[RED](#,##0)








You can choose same color again and again.