determining if cell text string is multicoloured and change.

Hi There,

I have a range of cells some of which may have their contents in two colors for example:

123/456 the "/456" may be a different colour to "123" but it equally could be "456" being a different color to "123/" fortunately the color of the '2nd segment' will always be a light blue (defined as: font.colorindex = 23)

any idea's how I can check the font colour of a specific part of a text string?

Originally Posted by TMS

Please Login or Register  to view this content.

Regards, TMS

This is perfect, in my first run I arbitrarily re-formatted every cell with a "/" which worked fine in a test range of 2000 cells worked fine but slowed down when I started on the real data of 200K cells (not by much but by enough) this has allowed me to skip cells that don't need any action and has provided a significant speed boost.

thank you.