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.
Bookmarks