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!