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

Forum|Forum|9 years ago
April 25, 2017
2 replies
777 views

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.

This topic has been closed for replies.

Correct answer try67

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;

try67

Correct answer

Community Expert

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;

D

dmdowsettAuthor

Participant

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

Community Expert

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

G

gkaiseril

Inspiring

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".

D

dmdowsettAuthor

Participant

Right but it only seems to work on whole numbers.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded