• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 98
  • 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?
Jass Saini
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
Gustav BrockCIOCommented:
Conditional formatting is too slow for this if the field is numeric.

Set the Format property of the field to:


Jass SainiAuthor Commented:
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.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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