How can I use conditional formatting for numbers with up to 5 decimal places.

[dmdowsett]

I have a number range from 1.77150 to 1.77221 and I would like it to turn red if it is outside that range.

[gkaiseril]

You have to use the custom JavaScript option on the Validation tab for the field's properties. Since you are focused on that field when validating, use the "event.value".

[dmdowsett]

Right but it only seems to work on whole numbers.

[try67 · Accepted solution]

As the field's custom validation script enter this code:

if (event.value>=1.77150 && event.value<=1.77221) event.target.textColor = color.red;
else event.target.textColor = color.black;

[dmdowsett]

OK, for some reason that didn't work, but I changed the color coding around so first line black and second line red and that was it, thank you.

[try67]

Sorry, I didn't notice you want it to be red if it's outside that range. Yes, changing the colors should solve that.