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.
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.
