I am running a VLOOKUP formula, where I am getting a lot of #N/A becuase I
don't have supporting information from the table I am looking up from.

How can I rid the #N/A. Is there something in Conditional Formatting I can
do to at least "hide" the #N/A?