Cconditional formatting on cells containing a VLOOKUP formula?

T

Tony Goossens

Hi,

I have a similar question to something that was already posted, however it
is different. Here it is:

I have a work sheet that has actual numbers in the cells of a column and
values from a VLOOKUP formula in another. What I want is to have the values
in the VLOOKUP column turn red if they are less than or equal to the numbers
in the other column, in the same row. I've tried many differnt things, but
nothing seems to work. Is this possible?

Tony
 
B

Biff

Hi!

=AND(ISNUMBER(A1),ISNUMBER(B1),B1<=A1)

A1 = cell with number value
B1 = result of lookup formula

Biff
 
Top