Excel - Cross Referencing 2 Columns

  B33J 13:33 03 Apr 08
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 08

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now