No built in formula, but see
http://www.xldynamic.com/source/xld.ColourCounter.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ing" wrote in message
...
Hello. This is my first time posting. I am working with a rather large
excel file.

It is color coded. Is there a formula that I can use that will take a
color
of the text - like "blue" and add a code into a given field for what that
color means?

thanks so much!