Excel regular text box font change color

Hi,
i have many regular text boxes with its values link to cells.

I want to change the font color in the text boxes based on the cell value, eg. Below 80 is red, above 81 is green.

I have searched thru the wen but couldn't find much info about it, anyone can enlighten me, thank you.

Note: I use the regular text boxes, not the one in developer form control.

Re: Excel regular text box font change color

Hi,

Ya, I put text boxes to point some info in graph, some graph color overlay the textbox, so was thinking to switch the textbox font color base on cell values

Thanks for your reply