Conditional formatting using combo box selection

[caniread]

I want to setup conditional formatting that will turn the box green or red. The problem is that the values need to change depending on a combo drop box value. Is there an expression I can use to tell it to look at the combo box then use a certain value depending on the combo box?

[June7]

Yes. What exactly do you not understand about setting Conditional Formatting? Start a New Rule and select Expression Is.

Are the combobox and textbox on same form? Is the combobox value number type?

[comboboxname]=something

[caniread]

Combo box and text box is on the same form. Combo box are names text box are numbers. Here is a better explanation I think. If combo box = this name then between these two values go green. Here is what I tried but is not working. [Material]![Material]="CA10A" & [Results]![Melt Flow] Between 0.45 And 0.8

[June7]

& is for concatenation, not logical expression.

[Material]="CA10A" And [Melt Flow] Between 0.45 And 0.8

I am not sure BETWEEN AND will work so maybe:

[Material]="CA10A" And [Melt Flow] >= 0.45 And [Melt Flow] <= 0.8

[caniread]

Thank you!!!! Had to tweak it a little but got it to work. Had to use the ID # instead of text "CA10A". Not sure why it didn't work the other way.

[Material]=1 And [Melt Flow]>=0.45 And [Melt Flow]<=0.8

[June7]

Because the value of the combobox is the ID not the alias text displayed.