Conditional Format Multiple Userform Textboxes dependent on value

Hi,

I have 58 text boxes all of which can have a value from -32 to 40 and im trying to set a colour od the textbox dependant on its number,

between -32 and -3 is one colour
between -2 on 0 is another colour
and
between 1 and 40 is another colour.

Ive tried using various bit of code but cant quite get anything to work.

Has anyone got any insights to share?

Thanks in advance

The below code is the closest I have got,

I have also posted this here http://www.ozgrid.com/forum/showthre...767#post773767

Please Login or Register  to view this content.