Conditional Format Question

[Guest]

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.

 

[Dav]

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

 

[Guest]

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).

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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