Could someone please tell me if it is possible to use conditional formatting on one cell that is based on several different simultaneous criteria that include the value in another cell? Or do you have to employ VBA for that kind of fun?

For example, I have a drop-down list in one cell (lets say it's C1) that has two values in it that a user can choose from. I want another cell, uh... cell B1, to change to red if cell C1 has "apple" selected and the value in B1 is greater than 4, but I want it B1 to turn green in color if C1 has "pear" selected and B1 is greater than 8.

It seems straight-forward enough to be able to do without VBA, but I'm not so sure anymore...