Lookup table color

  • Thread starter Thread starter sdrk
  • Start date Start date
S

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?
 
Hi
You could use conditional formatting. Use the same formula as the cell and
if < 0 then highlight the cell.
 
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))"
 
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
 
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
 
Back
Top