Excel doesnt natively support formulas with color....

youll have to use the Excel VBA editor and use/make code similar to this: http://www.cpearson.com/excel/colors.htm