OpenOffice Calc - conditional formatting of cells

[Jumbuck]

I'm trying to create a simple spreadsheet for checking lottery numbers.

So I have cells that contain the numbers that I have seleceted for the draw and I have 6 cells (adjacent, in the same row) into which I type the numbers as and when they are drawn.

What I want is for the background colour to change for any of my numbers which match any of the drawn numbers. I can do this using conditional formatting for each of those cells: the simplest way is to match against each of the drawn numbers individually BUT there are only three conditions available, not enough for all 6 numbers.

So

1. Can that default of 3 conditions be changed to another number (e.g. 6)? OR
2. is there statement which checks for matching the individual values within several cells ? (something like 'current() IN c3:h3')?

I only have a fairly basic knowledge of what conditional statements are available within spreadsheets, and haven't seen anything in the help text that is useful.

Thanks for any suggestions.

[vascop]

I'm not familiar with OpenOffice calc, but why is there a 3 condition restriction. I would expect you to be able to write:
if(condition1 OR condition2 OR condition3 Or condition4 OR etc) upto whatever you like - 6 in your case.

[Jumbuck]

With the cursor in a cell, selecting 'Conditional Formatting' from the Format menu (no equivalent in the context menu) brings up a pop-up window:

1st field is a drop down menu allowing selection of either 'cell value is' or 'formula is'
2nd field is another drop down menu for the comparison type e.g. 'equal to' (comparison with a single value)
3rd field is a text box for specifying the item/number/formula for the comparison.

I've tried using combinations such as 'C3 OR D3 OR E3...' but none of them work. only a single cell reference seems successful

And there is physically only 3 of these sets of fields. I've never used Excel but pictures on some websites seem to show that there is an ADD option at the bottom of the equivalent pop-up window which suggests that any number of conditions may be specified using that program.