Excel 2007 : Conditional formatting for greater than Vlookup result?

Is it possible to use a greater than vlookup formula in conditional formatting?
I have a set of values in column C in sheet 1, that I want conditionally formatted to show whether the figures are higher or lower than their counterparted figures in column C in sheet 2.

For instance, if client H8765 Has 74,326 on sheet 2, but 75,895 on sheet 1, I want the field on sheet 1 to be coloured green.
The problem is that the data wont necessarily be on the same row on sheet 2.

Is there a way to combine the greater than conditional formatting with a Vlookup?