Option button, drop down list colour option

[xlbeginnerxl]

[TABLE="width: 500"]
<tbody>[TR]
[TD]product[/TD]
[TD]comment[/TD]
[TD]action[/TD]
[TD]financials[/TD]
[/TR]
[TR]
[TD]xyz[/TD]
[TD]a
b
c
d
e
f

[/TD]
[TD]red[/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]yxz
[/TD]
[TD]a
c
d
ge
as
dg
ae
ag

[/TD]
[TD]red[/TD]
[TD]amber[/TD]
[/TR]
[TR]
[TD]abc[/TD]
[TD]a
adf
adag
ada

[/TD]
[TD]amber[/TD]
[TD]green[/TD]
[/TR]
</tbody>[/TABLE]

hi i have a table similar to above. in the action and financials column, i would like to add the option to select three colours (red, amber & green). I can do this by doing data validation, and then selecting (red, amber and green) and then conditonnaly formatting the cell for each text. The only downside is that it fills the entire cell in that colour and this is a downside because the comments are long which expands the the entire row to show text and thefore the action/financials cell expand and so does the colour based on the choice.

What I would like is same feature, the ability to select either red, amber or green and reflect that colour based on selection without the whole cell being covered. I tried option button which changes background colour when selected but that colour doesn't change when another colour is selected. i.e. when red is selected, small red box lights up but when amber is selected, red stays from prior selection

Is there way to achieve what I'm trying to do. Any help would be greatly appreciated.
Thank you