austenr
09-06-2005, 01:36 PM
I am trying to use this formula in conditional formatting to highlight every occurance of B not found in A. I think I am missing a ) or something:
=(COUNTIF($A:$A,B1)=0*(B1<>"")"
any help is appreciated. Thanks
=(COUNTIF($A:$A,B1)=0*(B1<>"")"
any help is appreciated. Thanks