Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Conditional Formatting Issue in Excel

  1. Feb 22, 2012 #1
    Hi everyone.

    I have never worked in-depth with Excel and I am trying to make my life a bit simpler doing some data cleaning using the 'conditional formatting' option. My scenario is the following:

    I have two columns of data, column A and column B. I would like to take each entry (a string of text) in column A and see if it exists anywhere in column B. If it does, I would like to highlight it one color, and if not I would like to highlight it another color. Actually, just highlighting one of the two cases would work.

    I have figured out how to do this with one entry. I type


    into the formula box under conditional formatting. This checks to see if the string in A2 exists anywhere in column B (i.e. from B2 to B35). If it does it will highlight it. However I cannot seem to generalize this to apply to every value in the column of A.

    Any advice?
  2. jcsd
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?