Question Conditional formatting > 3

[icbiny]

i'm trying to apply a format to a control with more than 3 conditions.
i tried "field value is" "equal to" "me.text0 or me.text1" etc, trying a few variants like "or =me.text1" without success. i can apply 3 seperate conditions using the access tool which works fine, but i need 6!
can any1 offer a simple solution?

thx.

 

[pr2-eugin]

More information, like what type is the field, what are the conditions to check for, can it be VBA other than the inbuilt validation tool?

 

[icbiny]

its a number field to check our staff lottery each week....
so i have 10 records of 6 numbers on a continuous form. i enter the 6 winning numbers on the header of the form and am trying to get any matching numbers to highlight e.g change the backcolor

 

[pr2-eugin]

I am totally lost, can you please explain with giving an example?