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' ???
Bookmarks