Read Colour of Text and Assign Value

[markexcelhell]

Hi All

This is my first post so I apologise if I have put it in the wrong place or in the wrong format but I am in need of some expert advice.

I have a process I go through which is extremley long winded and I am convinced that I can automate most of the processes. So i have decided to break this down into sections otherwise this will be a never ending post.

Step one - Output

I have a peice of software that outputs a list of hyperlinks which are colour coded for different categories Class 1, Class 2 and Class 3. Is there a way for excel to read the colour of the text and assign a class in the cloumn next to it?