Javascript to Highlight Cell

Aug 24, 2020

Copy link to clipboard

Copied

Hoping someone can help me create a javascript to highlight the cell when a negative number is entered and when the formula, that is already in place, results in a negative number.

 

Thanks!!

You can add something like this to the end of your calculation script:

 

event.target.fillColor = (event.value<0) ? color.yellow : color.transparent;

TOPICS
PDF forms

Views

22

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Javascript to Highlight Cell

Aug 24, 2020

Copy link to clipboard

Copied

Hoping someone can help me create a javascript to highlight the cell when a negative number is entered and when the formula, that is already in place, results in a negative number.

 

Thanks!!

You can add something like this to the end of your calculation script:

 

event.target.fillColor = (event.value<0) ? color.yellow : color.transparent;

TOPICS
PDF forms

Views

23

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 24, 2020 0
Aug 24, 2020

Copy link to clipboard

Copied

You can add something like this to the end of your calculation script:

 

event.target.fillColor = (event.value<0) ? color.yellow : color.transparent;

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 24, 2020 1
Aug 24, 2020

Copy link to clipboard

Copied

Thank you!!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 24, 2020 0