I have a very complicated formula that says, add these two cells and if it is
less than zero to go to a lookup table and display the results in the the
table. my question is, how can make it higlight the cell or use the color of
a cell in the lookup table so i can easily tell that it is getting the data
from the lookup table and not the added cells?

Hi
You could use conditional formatting. Use the same formula as the cell and
if < 0 then highlight the cell.



"sdrk" wrote:

I have a very complicated formula that says, add these two cells and if it is
less than zero to go to a lookup table and display the results in the the
table. my question is, how can make it higlight the cell or use the color of
a cell in the lookup table so i can easily tell that it is getting the data
from the lookup table and not the added cells?

That will not do it. it has to ad 2 cells and post the lookup table data if
it is less than zero or over 8. the formula looks like this
"=IF(AND(L2-J2=0,L2-J2<=VLOOKUP(H2,time2,2,FALSE)),L2-J2,VLOOKUP(H2,Job_Code,2,FALSE))"

"Sandy" wrote:

Hi
You could use conditional formatting. Use the same formula as the cell and
if < 0 then highlight the cell.



"sdrk" wrote:

I have a very complicated formula that says, add these two cells and if it is
less than zero to go to a lookup table and display the results in the the
table. my question is, how can make it higlight the cell or use the color of
a cell in the lookup table so i can easily tell that it is getting the data
from the lookup table and not the added cells?

Try this:

Select the cell in question
Goto the menu FormatConditional formatting
Formula Is: =L2-J2<0
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"sdrk" wrote in message
...
That will not do it. it has to ad 2 cells and post the lookup table data
if
it is less than zero or over 8. the formula looks like this
"=IF(AND(L2-J2=0,L2-J2<=VLOOKUP(H2,time2,2,FALSE)),L2-J2,VLOOKUP(H2,Job_Code,2,FALSE))"

"Sandy" wrote:

Hi
You could use conditional formatting. Use the same formula as the cell
and
if < 0 then highlight the cell.



"sdrk" wrote:

I have a very complicated formula that says, add these two cells and if
it is
less than zero to go to a lookup table and display the results in the
the
table. my question is, how can make it higlight the cell or use the
color of
a cell in the lookup table so i can easily tell that it is getting the
data
from the lookup table and not the added cells?

thanks to both of you, figured it out. I made the conditional formula to
say if not equal to the sum of those to cells. you both got me going in the
right direction.

SDRK
"T. Valko" wrote:

Try this:

Select the cell in question
Goto the menu FormatConditional formatting
Formula Is: =L2-J2<0
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"sdrk" wrote in message
...
That will not do it. it has to ad 2 cells and post the lookup table data
if
it is less than zero or over 8. the formula looks like this
"=IF(AND(L2-J2=0,L2-J2<=VLOOKUP(H2,time2,2,FALSE)),L2-J2,VLOOKUP(H2,Job_Code,2,FALSE))"

"Sandy" wrote:

Hi
You could use conditional formatting. Use the same formula as the cell
and
if < 0 then highlight the cell.



"sdrk" wrote:

I have a very complicated formula that says, add these two cells and if
it is
less than zero to go to a lookup table and display the results in the
the
table. my question is, how can make it higlight the cell or use the
color of
a cell in the lookup table so i can easily tell that it is getting the
data
from the lookup table and not the added cells?