Text Box Change Color on Calculation

[MarkV]

Hello,
I wanted to have a text box at top of form and put a value in it that says 50-100.
I want to make another text box that has the user enter a value.
If they enter a value like 75 it is in the middle so it stays white. If the value is in the lower third of that value (50-100) change color to Pink. If value is in Higher third of value change to Yellow. If out of range below the (50) value change to Green. If out of value Higher than (100) change to Blue.

I need white for somewhere in middle of range. Something in lower third. Something for out of range lower than value, and same for Higher. A color for upper third value and a color for Out of range Higher that top value (100)

If someone can help someway thanks. If you have a different idea please help.

Thank you so much
Im new and building my own and soing good so far.

Just need to enter specification form. and a result subform with colors people enter



Best
Mark

[NTC]

a field that would hold: '50-100' can only be a text field on which you cannot apply math. So you need a field with 50 and a field with 100 that are number field types....whether or not they are seen by the user is up to you.....

once you have that then experiment with Conditional Format feature for the field you seek - it might be a little tricky to write out the expression....but I think it can be done

modifying the font or background color property via vba is an alternative that will definitely work but I would try the Conditional Format approach first....

[MarkV]

Thank You so much. I will give it a try right now.