Do I use conditional formating?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a vlookup formula
=VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job List'!$A$1:$K$324,4,FALSE)
to get a value in another worksheet.
If i want to add a conditional format (and i am not sure if that is what i
need to add)
so that if this cell is less than another cell, it gives me a zero value,
what do i need to add to this formula?
Thanks
 
=IF(VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job
List'!$A$1:$K$324,4,FALSE)>A1,VLOOKUP(A7,'[UNION WAGE SHEET.xls]UT Job
List'!$A$1:$K$324,4,FALSE),0)

replace A1 with the "other cell"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
vlookup formatting problem 1
Conditional Formatting 1
Conditional Formatting 2
conditional formatting 6
Conditional Format Won't Update Cell 8
Excel VBA 1
return blank cell if condition met 2

Back
Top