title: How can I mark duplicate values in a column based on a second value in a different column in Excel 2007?
body: <p>I have been trying to mark duplicates in the same excel column based on a criteria in a different column, and I would love to have some help.  In reference to the example below, I would like to highlight all the rows that is a duplicate value of another row red, and put a Y in a third column ("Delete" in the example below).  When the value in the Name column is a duplicate of another, disregarding case sensitivity, I would like to mark all but one value based on a hierarchy in the Status column, i.e Excellent, Good, and Bad.  </p>
  
  <p><img src="https://i.stack.imgur.com/zIi2I.png" alt="enter image description here"></p>
  
  <p>Only one of each unique value can be left unmarked, and if two share the same status with no duplicate value of a higher status then either one can be marked (the one further down the list if thats easier to specify). </p>
  
  <p>I have been looking around the site and have found lots of similar entries on deleting duplicates but nothing quite the same.  I need to highlight and not delete the duplicate rows and I have not been able to find anything that will let me sort based on a heirarchy in a second column.  I only need to execute the command once as oppose to on a recurrence so the time it takes is not a concern to me.  Any help you guys can throw my way would be greatly appreciated.</p>