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?