I have created a workbook for calculating commissions. I import invoices
from QuickBooks into a template that includes a table with inventory cost.
I need to know when an item that is imported is not on the table. Right now
I use vlookup with the FALSE attributr to find cost and, as it should, this
gives a #N/A error. I would like to instead change text color or the cell
background color in the cell with the incorrect item. I have looked around
and cannot find how to do this. Any help? (I prefer to stay away from VBA
if possible)

Dave