If you reread the original question, I believe you will find that the interest
is on formatting parts of a cell (individual characters) - not the whole cell.
Also that the part about changing the background colour wanted eight different
colours. Both of these are well beyond conditional formatting.