Adding codes based on a font color

[Ing]

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!

 

[Bob Phillips]

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)