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!