View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default Conditional Format Question

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.