Ardson2412
New member
- Joined
- Oct 31, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I have a list of data containing several thousand rows.
I need to higlight every 3rd 'letter' so C, F, I etc . The problem is that data contains groups of random sizes. Here is an example below
A 1
B 1
B 2
B 3
C 1
C 2
D 1
I need to be able to change the colour (background or text) on every 3rd character as well as rest of the group ie C 1 &2
Hope you can help
I need to higlight every 3rd 'letter' so C, F, I etc . The problem is that data contains groups of random sizes. Here is an example below
A 1
B 1
B 2
B 3
C 1
C 2
D 1
I need to be able to change the colour (background or text) on every 3rd character as well as rest of the group ie C 1 &2
Hope you can help