I want a VBA script to change each sentence in a paragraph with a different colour.
So the script word look for a full stop (.) and then assign one colour to sentence 1 and then see a full stop and then assign a different background colour to sentence 2 etc.
You could load the script with say 10 different colours.
Is this possible?
I can't see a solution for this elsewhere online.