title: How to conditionally format highest value of multiple ranges
body: <p>I'm trying to use conditional formatting to highlight the maximum value over multiple ranges. That is, find the one highest value in said ranges and highlight all instances of it. I have been able to use conditional formatting to highlight the highest number of one column, but not over multiple.</p>
  
  <p>The ranges in question are: <code>G3:G13,J3:J13,M3:M13,P3:P13,S3:S13,V3:V13</code></p>
  
  <p><a href="https://i.stack.imgur.com/HBhvD.png" rel="nofollow noreferrer">Screenshot of the spreadsheet</a></p>
  
  <p>The versions I have tried either highlight every value in the first row, multiple values but not the highest one, or nothing at all.</p>
  
  <p>An alternative is to use a MAX function and place that value in another cell (the little 4 in the bottom right corner) and use conditional formatting based on that value. However, it's not a particularly elegant solution nor have I been able to make that work properly.</p>
  
  <p>I am using New Google Sheets and am familiar with custom formatting and custom formulas for doing so.</p>