Need Help with Conditional Format

[sachin30us]

So i did a HLOOKUP in comparing two table columns. The Hlookup came back with errors for data that didnt match the table column names. Is there a way for me to highlight the cells in C2 if Cell A2 has #N/A in it?

 

[Special-K99]

Select

Conditional Formatting
New Rule
Use a formula to determine...

=(ISNA(A2))

Format as required
Use Format painter (paintbrush icon) to copy to other cells