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

5 replies
787 views
Translate

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 is closed to new replies. Start a new post to keep the conversation going.

try67Correct 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;

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;

Translate

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.

Translate

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.

Translate

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

Translate

D

dmdowsettAuthor

Participant

Right but it only seems to work on whole numbers.

Translate

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.