Returning a count of how many letters in a string are a certain font colour

[scott0808]

Hi there,

I am doing a piece of analysis work using a VBA macro which compares two addresses and highlights any character differences in red.

Now that I have run this, I want to be able to find out how many characters within each cell are red. I've found solutions for finding how many cells have red text but that adds them as whole. I need it to be broken down to character level.

E.g. If I had the address 221 B Baker Street and the letters Baker and eet were highlighted red, the formula could be used in the next cell to return the value 8 as 8 letters are red (Baker and eet).

Any help would be greatly appreciated.

[Haluk]

You can use the below function:

Please Login or Register  to view this content.

Usage on the sheet is:

Please Login or Register  to view this content.

Enter this in cell B1 and see the number of characters in red in cell A1.

[scott0808]

This worked an absolute treat. Thank you very much for your help and quick response!!!!!

[Haluk]

You're welcome...