VBA - Formatting TextBox (Shapes) text colour and arrow based on linked data

[shhykk]

Hi,

I have some movement data that can either be 0, >0 or <0. They are in cell C18, C19, C20. [Variable Cells]

They are linked into 3 textboxes (Insert > Shapes >Textbox). I want to be able to change the font colour in these textbook to green when the Variable Cells are >0, and red when <0, and yellow =0. It would be great if the textbook also include an arrow up/down/flat as well.

Is there a way to do it?

All these (textboxes and variable cells) sat on a worksheet called "Dashboard".

THank you.

Kind regards,
shhykk

 

[shhykk]

Thank you so much Dante! It works perfectly!

Sorry over the night, i added some rows, that's why it looks like circulate reference. my bad! Thank you so so much for all your help!

 

[DanteAmor]

Im glad to help yout. Thanks for the feedback.