This question about conditional formatting appears to be easy.
Lets say I have a column like the following, like I posted somewhere else: (not very relevant for this)

BGW
3UG
WWU
1BR
UUBRG
WUBRG
7UUGGRRR

How do I have all characters in this column be coloured accordingly to:

W = WHITE
U = BLUE
B = BLACK
R = RED
G = GREEN

So that 7UUGGRRR would automatically switch to:
7UUGGRRR

What I already tried:
- I applied conditional formatting to the column (actually, the cells interval, [C2..C8]) creating the rule: 'format only cells that contain -> specific text' -> then I added "U" as the text and told it to colour blue. As I predicted, this didn't work; the entire cell containing a single "U" will get blue, which is unwanted.

Thanks.