Cconditional formatting on cells containing a VLOOKUP formula?
 

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

Hi!

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

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

Biff

"Tony Goossens" wrote in message
...
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