I think Jonathan Drummey's Older But Still Useful – Conditional Formatting | Drawing with Numbers will help you with this. Hold on to your hat, it seems pretty daunting at first! Pretty cool, though, once you learn it.
I had referred this article earlier but didnt understand much at first time, however your persistence to continue with it helped!! Thanks.