| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I use "#N/A" return from a vlookup to change row color?
The row that returns "#N/A" from =VLOOKUP(H2,Compare!$A$2:$K$890,11,FALSE)
would help a lot by coloring the row green for non-#n/a and red for #n/a. This way I know right away that the information exists in the other speadsheet or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and bring the "font color" of the cell across? | Excel Worksheet Functions | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| get the VLOOKUP function to return the "contents" of a cell? | Excel Worksheet Functions | |||
| IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE") | Excel Programming | |||
Threaded Mode
