Sure. In cell B2, Format Conditional Formatting. Set the first drop-down
to 'Formula Is' and enter =isna(a2) as the formula in the text box. Then
choose the format you want to appear when #N/A is in column A, and click OK.
Copy the format to additional cells in column B (or just highlight the rest
of column B and ctrl+Y to repeat conditional formatting).

"carl" wrote:

My table looks like this:

ID
50 50
60 60
355 355
549 549
642 642
910 910
912 912
913 913
914 914
918 918
919 919
931 931
937 937
947 947
958 958
#N/A 969
980 980
#N/A 989

ColA has a formula formula in it. Is it possible to use the conditional
formating function on ColB to highlight the ID's that correspond to the
#N/A's ?

Thank you in advance.