Change Textbox Backcolor (multiple textboxes)

Hi,

I have 5 textboxes on a userform. I would like to be able to change the backcolor of all of them to be the same if one changes.

I will try to explain this a little better

The backcolor of each of the 5 textboxes can change if the value meets a criteria:

If value less than 2 textbox is green (good - lowest score)
If value between 3 and 4 textbox is orange (ok)
If value is over 4 textbox is red.(bad - highest score)

This is applied to each textbox individually and works fine. So I could have one red box, two orange and two green.

What I would like to happen is this:

If any of the boxes are red - all boxes need to go red.
If there are no red boxes and one of the boxes is orange - all boxes need to go orange.


Does anyone know if this is possible?