Excel 2007 : Conditional formatting for greater than Vlookup result?

**Nikeyg** · 03-15-2012, 04:37 AM

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?

**veejar** · 03-15-2012, 04:58 AM

Hi Nike,

Please post a sample sheet, It would be quicker that way

**Fotis1991** · 03-15-2012, 05:07 AM

Hi

Let's say, that your Names are in both Sheets, in Column A and your Values in Column C.

In Sheet 2 , give Names(Insert>Name>Define). Names for A:A and Values for C:C

Then, in Sheet1, Highlight your range and in Conditional Formatting rules, put this formula.

=$C1>(INDEX(Values;MATCH($A1;Names)))

Choose green color and press OK.

Is it OK, for you?

**Nikeyg** · 03-15-2012, 06:11 AM

Thanks guys.
I think I've worked it out:
I'm using the below code in my Conditional formatting, and it seems to be working ok

Please Login or Register  to view this content.

I'll admit though, I'm not the best at conditional formatting. So there may be something I'm missing that may not work. Any suggestions will eb gratefully received.