Changing colors of the field based on the input

How do you make a field red if the field is a number and the number is negative?
Jass SainiAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
you can use conditional formatting

select the control and click Conditional formatting

Field Value is    less than        0

select the red for background
0
 
Gustav BrockCIOCommented:
Conditional formatting is too slow for this if the field is numeric.

Set the Format property of the field to:

   0.00,\-0.00[Red]

/gustav
0
 
Jass SainiAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.