Is it possible to conditional format for specific terms within a cell.

e.g. the addition a letter or letters to a number will change the colour of
the cell.

1A = Red
10B = Yellow
100AB = orange.