Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup with conditional formatting
I am currently using vlookup to lookup two concatomered columns. I would
like to highlight red when no value comes back. This would indicate a sample that has to be repeated in our analysis. For some reason, when I used original data to build the formulas, if vLOOKUP could not find the data for values in my list it would return a zero. Now that I have my template that I paste data into, it retuns the #NA result. I haven't been able to conditionally format for this #NA? Is there a way to do this? Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup with conditional formatting
You could wrap your vlookup in an if function to return a zero like
=IF(ISNA(VLOOKUP_Formula),0,VLOOKUP_Formula) then format conditionally on 0 or perhaps you can use or use conditional formattingformula is =ISNA(A2) where A2 holds the vlookup formula Regards, Peo Sjoblom pm wrote: I am currently using vlookup to lookup two concatomered columns. I would like to highlight red when no value comes back. This would indicate a sample that has to be repeated in our analysis. For some reason, when I used original data to build the formulas, if vLOOKUP could not find the data for values in my list it would return a zero. Now that I have my template that I paste data into, it retuns the #NA result. I haven't been able to conditionally format for this #NA? Is there a way to do this? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup for Conditional Formatting | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) |