Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
Formatting Cells | Excel Worksheet Functions | |||
background formatting across multiple cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |