Conditional Formatting based on another selection

[crazy loud]

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...

[mikerickson]

VBA is not needed. The Custom Formula option of conditional formatting can be used.

=AND($C$1="apple",$B$1>4)
=AND($C$1="Pear",$B$1>8)

would be the formulas used for your example. Custom Formula is very useful. It can be used in Validation, AdvancedFilter, and DataBase formulas.

[crazy loud]

Thanks mikerickson! I had tried the AND before, but was putting it in the wrong place.