Conditional Formatting of a text box.

[JoyC]

I'm wondering if there's a way in which I can change the colour/shade and font colour of a text box in Excel when a particular cell displays specific values.

For instance, if cell "P5" displays "R" I would like text box 1 to display a shade of red with the contents in bold white font. If "P5" displays "A" it needs to be amber with regular black font, if "P5" displays "G" it needs to be green with regular black font.

I'm happy to use VBA, in fact I would say this is the only option.

If you need any further clarity, I'd be happy to elaborate.

Many thanks.

 

[JoyC]

NB: I should add, after investigating this myself that I am referring to the textbox found on the Autoshapes toolbar and not the textbox used on a userform.