Write VBA to dynamically change colour of text in textbox depending on contents

Job ID: 30951816

Budget: $10 – $30 AUD

Using the attached file, I need someone to write some VBA so that whenever something changes on the current sheet or the sheet is made active, the text boxes are coloured green if they contain ▲ and red if they contain ▼.
Related categories: Visual Basic Excel Visual Basic for Apps