Lookup table color

[sdrk]

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?

 

[Sandy]

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

 

[sdrk]

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))"

 

[T. Valko]

Try this:

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

 

[sdrk]

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