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