Conditional Formatting or number field
Hello there,
I'm trying to change the format of text depending on a text field value
I don't know where is the wrong in my code!
it's not working
what I want is:
make the text red bold and italic if Actual_lodgning_1 > lodging_per_diem_1
Thanks in advance
This is the code:
if(event.value>Number(this.getField("lodging_per_diem_1").value))
{event.target.textColor = color.red;}
else if(event.value < Number(this.getField("lodging_per_diem_1").value))
{
event.target.textColor = color.black
event.target.fillColor = color.transparent;}
Actual_lodgning_1

