title: Conditional formatting depending on the extreme values of each row
body: <p>I'm trying conditionally to format a Google Sheets sheet with 1,000 or more rows. I have to colour it depending of the highest and lowest value of each row.</p>
  
  <p><img src="https://i.stack.imgur.com/Z4YqK.png" alt="Example image">
  (Red=highest,green=lowest) I want to make the second example without having to write every row B1:F1,B2:B2, etc, because it is a large document.</p>