Excel - Cross Referencing 2 Columns

  B33J 13:33 03 Apr 2008
Locked

Hi,

I have some data in excel in 2 seperate columns. I want to be able to search through column 2 and if any data in that column appears in column 1 mark it somehow.

Any suggestions?

  VoG II 13:45 03 Apr 2008

Select your data in column B. Format > Conditional Formatting. Select Formula Is and enter

=COUNTIF(A:A,B1)>0

Select a format and OK.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?