I downloaded the form. I appreciate your effort, however, the form still does not work. For some reason on your form when you divide the firstlien (450,000.00) into the salesprice of (500,000.00) you get .9% instead of 90.00%. Maybe you changed the format. I can fix that but the color does not chang...

Thanks you so much!!! I havent been able to download the form you fixed but I do appreciate your help. The color codes I used came from Kuler. They are$.fillColor = "255,13,255"                elseif ($ gt 90) then                        $.fillColor = "188,40,29"                else                 ...

I changed the code today to:Form1.#subform[0].LTV1st::calculate - (FormCalc, client)if(FirstLien gt 0 and SalesPrice gt 0) then                 $ = FirstLien / SalesPrice                if ($ gt 80 and $ lt 90) then                        $.fillColor = "255,13,255"                elseif ($ gt 90) th...

I dont know how to upload a form to this site. The form can be downloaded from box.net.The link to the form is: https://www.box.com/s/61n32urjw3xglsjnhjg4Thanks again.

Using the following code, the results are the same.if(FirstLien gt 0 and SalesPrice gt 0) then            $ = FirstLien / SalesPriceif ($ gt 80) then                                $.fillColor = "50,62,49"           elseif ($ gt 90) then                                $.fillColor = "75,100,75"      ...

Thank you. The only color that works is the "else" fill color of 208. The form does not calculate or change with the percentage. This is the code i'm using.if(FirstLien gt 0 and SalesPrice gt 0) then            $ = FirstLien / SalesPrice           if ($ gt 80) then                                $.f...

I am trying to connect the following codes to work together. The way it's constructed one code will work but not the other, this is also true when the code is reversed. The 1st part of the code represents a change in the percentage and the 2nd part of the code calculates the actual percentage.The pe...

I tried simply cutting and pasting the code you sent. It doesnt calculate with this on top.  If(FirstLien>0 and SalesPrice>0) then LTV1st = FirstLien / SalesPrice;endif if ( LTV1st > 90) then$.fillColor = "255,255,133"elseif (LTV1st >= 80 ) then$.fillColor = "74,165,116"else $.fillColor = "208,208,2...

It may be easier to send you the form. The code below is the current one i've tried, it does the auto-calc for the percentage field but not the change in color shade. LTV1st.ui.oneOfChild.border.fill.color.value = "74,165,116";var sum = LTV1st;if ( sum >= 80) then$.fillColor = "74,165,116"elseif (su...

I had changed it before your post, it seems to make no difference. Either the number calculates or the color changes, the code the way I have it constructed doesn't do both.Thanks again.