Gary wrote:
It doesnt explain anything.

"Carim" wrote in message
ups.com...
Hi Gary,

Have a go with following example with 26 conditions ...

http://www.rhdatasolutions.com/Condi...eThan3Cond.xls

HTH
Cheers
Carim



Try following steps, this does not require any VBA.

1. Make a table for results of all your possible conditions
2. in column 1 write expected results eg. A to J, and colum 2 write 1
against each
3. Give this table a name eg Table
4. Write a formula in your column 6, =VLOOKUP(E2,table,2,FALSE) E2 is
your column 5
5. If the result is according to your possible conditions, it will
return 1 in cell F2
6. Select cells A2:E2 and just one conditional format by selecting the
Formula =$F2=1 choose your highlighting colour in the condition

This will work.
Regards.
Aqib Rizvi