Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I have a cell, E3, containing a two letter value ("CO")
I am looking for a VBA solution to change the colour of the first letter ("C)" red, while leaving the "O" the default colour.
Can anyone suggest an idea? I can change the cell font color, but I just need to find a way to do one letter at a time.
I am looking for a VBA solution to change the colour of the first letter ("C)" red, while leaving the "O" the default colour.
Can anyone suggest an idea? I can change the cell font color, but I just need to find a way to do one letter at a time.