Conditional formatting for cells containing multiple values.

The sample excel enclosed contains multiple values in single cells. Even some values are in brackets. Those values are generated with some other calculations and they are from 1 to 12. (i. e. among 12 houses of astrology chart)
Is there any way for conditional formatting such as:

1. Cells containing 6, 11 (any or both) should be 'Green'
2. Cells containg 8, 12 (any or both) should be 'Red'.
3. Cells containing both among above two groups should be 'Yellow' ???

Sorry for the delay in reply

Thanks for the links. I have tried as mentioned in links. But unfortunately the data in each cells (of 'sample excel') is not properly formatted so as to work 'conditional formatting.
The data in cells is a 'group' of houses (among 12). It is sometimes in bracket, sometimes without comma separated. and this data is changing (not constant)
This is the reason, I am not able to use conditional formatting as explained in the links you had provided.
Would be grateful to know how to use conditional formatting in such a situation.

@ bebo021999, I have really learned a lot by this suggestion. Thanks.

@ Tony Valko, It worked perfectly. Thanks.