title: Using conditional formatting to compare multiple cells in one row to another
body: <p>I'm trying to figure out what formula I can use to highlight duplicates in a spreadsheet.</p>
  
  <p>I want to compare data across multiple cells to see if it matches with other sets of cells with the same data.</p>
  
  <p>For example, given this data:</p>
  
  <p><strong>Name</strong>,    <strong>Food</strong>,    <strong>Animal</strong></p>
  
  <p>Donald,     Hamburger,      Alligator</p>
  
  <p>Rupert,  Sushi,     Alligator</p>
  
  <p>Christie, Hamburger,    Panda</p>
  
  <p>Donald,  Hamburger, Alligator</p>
  
  <p>I want to make excel highlight the 1st and 4th cells as all values are the same across all three cells. I've tried countif to create rules to highlight the duplicate cells but I cannot seem to get excel to compare across three cells. Is the only solution to use IF AND to compare each column one by one? The data set is several hundred rows long so I am trying to figure out a quick way I can repeat this check across multiple workbooks. I've tried to use the basic conditional formatting options provided by excel but haven't been able to get a good result using those.</p>
  
  <p>Thank you!</p>