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.

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.

format_conditional formating choose

for cell b1 =isna(a1) then format to whatever colour you wish then copy
it down as a format

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=556490

Use a formula of =ISNA(A1) in the CF.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"carl" wrote in message
...
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.