To be more specific:  I have a cell which shows me the inventory balance on hand.  A second cell tells me the level at which I need to place an order to refill that inventory.  I'd like the inventory balance cell to turn red when it drops below the re-order level in the second cell so that I can know what part numbers need to be re-ordered at a glance.

 

The highlighting expert doesn't seem to allow a conditional formatting on the basis of a value in a second cell .... which is infuriating.  :(

 

Any ideas?