Javascript to Highlight Cell

[#1]

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!!

[#2]

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!!

[#3 · Accepted solution]

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

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

[#4]

Thank you!!