I have a number of cells (D4:D39) containing event descriptions followed by 3 digit codes and I want to colour these codes differently depending on which group they belong to
<tbody>
D
4
ALL Groups
ABC - DEF - PQR - VWX - 21E - XY2
5
GROUPS2 and 3
MNO - STU - A1C - XY2
6
GROUP1, 2 and 4...