• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 97
  • Last Modified:

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?
0
Jass Saini
Asked:
Jass Saini
1 Solution
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now