title: Excel formatting/Highlight row based on the last date and equal cell value
body: <p>My question relates with the following.</p>
  
  <p>I have a matrix in Excel of values, I want to highlight the entire row if two conditions are met. Those conditions are:</p>
  
  <p>a. For equal values on column A compare its date;</p>
  
  <p>b. If the value is equal, highlight the row with the most recent date.</p>
  
  <p>Graphically its the following:</p>
  
  <pre><code>    A   B
  1   Y   04-08-2006
  
  2   X   02-07-2008
  
  3   X   12-05-2014
  
  4   Z   09-08-2014
  
  5   X   25-06-2016
  
  6   Z   01-04-2018
  
  7   Y   24-07-2018
  
  8   X   25-09-2018
  </code></pre>
  
  <p>I want to highlight the 6, 7 and 8 row with different colors.</p>
  
  <p>Can I do that with conditional formatting or its not possible and the only way is to write code in VBA?</p>
  
  <p>Thank you.</p>