Thanks once again!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!You are correct (for anyone who did not understand my question) - it is a drop down-list where 3 of the 8 options have the same condition to follow.The second suggestion of spelling out the entire condition worked like a charm.

I'm having the same issue now that my script includes more than one option from the drop-down list. Using the example above, I now have included the option of year 4,6, or 8:form1.#subform[0].#subform[1].#subform[2].YEAR4.TextField17::calculate - (FormCalc, client)if (form1.#subform[0].#subform[1].#subform[2].Row[0].YearLevel == "4" or "6" or "8" & ((B1P+BP)>".45" or (B1P+BP)<".30") & CourseNum>="20")then$.fillColor = "225,225,0";else$.fillColor = "255,255,255";endifHope you can help.

Thank you for taking the time to answer!!!!!

update - I've provided a screen shot below. I'm a newbie, so my terminology may not be correct as I describe my question.When the user enters data in the "number of students" row - the "percent of class total" is auto-calculated. Depending on the year level, class size, and percent of class the percent range the fields in the chart belwo change colour (see screen shot). My problem is that more than one field changes colour once the data is enetered although the script specifics the year level. I...