| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I use conditional formating?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Do I use conditional formating?
=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" "Pakmount" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| Multiple Conditional Formating | Excel Discussion (Misc queries) | |||
| excel conditional formating decimal fractions | Excel Worksheet Functions | |||
| Conditional formating using formulas | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Linear Mode
