Change color of text box on Form

  • Thread starter Thread starter Rubie
  • Start date Start date
R

Rubie

Hello,

I have a text box on a form that is setup to show percentage. How do I get
the text box to turn (Red if the percentage is 79 and below) and turn (Green
if the percentage is 80 and above)?

Any help on this would be greatly appreciated.
 
Place the form in design mode. Select the field you want. Right click and
select "conditional formatting".

On Condition 1 utilize if Field value is > value then select colour.

On Condition 2 utilize if Field Falue is < value then select colour.

Cheers
 
It worked!! Thanks a bunch Kenny.

Kenny G said:
Place the form in design mode. Select the field you want. Right click and
select "conditional formatting".

On Condition 1 utilize if Field value is > value then select colour.

On Condition 2 utilize if Field Falue is < value then select colour.

Cheers
Click to expand...
 
Back
Top