0

I have a column on sheet1 with a list of names. I need conditional formatting on it to turn it red if that name does not show up anywhere on sheet2.

1

I figured it out.

=countif(indirect("sheet2!$A:$M"),$A1)=0

I'm not sure how to make it not color blanks though.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.