If/Then statement between 3 fields.

[tony1928]

All, I have the following fields; TC(total cost), MEL$, and SC. If TC >MEL$, I would want "EXCEED MEL" to populate the SC field in bold red font.

Thanks for everyones assistance in advance.

[Asim123]

Is normaly "SC" field not in bold and red color?

[tony1928]

No it is not. I will be adding other codes at a later date that will remain black.

[JR Boulay · Accepted solution]

Use this as a calculation script in the SC field (not tested):

if (Number(this.getField("TC").value) > Number(this.getField("MEL$").value)) {
event.target.textColor = color.red;
event.target.textFont = font.HelvB;
}
else {
event.target.textColor = color.black;
event.target.textFont = font.Helv;
}

Available colors: https://help.adobe.com/en_US/acrobat/acrobat_dc_sdk/2015/HTMLHelp/Acro12_MasterBook/JS_API_AcroJS/co...

Available fonts: https://help.adobe.com/en_US/acrobat/acrobat_dc_sdk/2015/HTMLHelp/Acro12_MasterBook/JS_API_AcroJS/Fi...

[tony1928]

Thanks for this script. It works to bold the text but does not change font color.

[tony1928]

Thanks JR Boulay. It is working now. I re-copied and pasted your script and it started working.