title: Color Scale entire row based on one column
body: <p>Suppose I want to color scale complete rows on the basis of values in a column (using Google Sheets inbuilt color scale option in the conditional formatting menu). How do I achieve this? </p>
  
  <p><img src="https://i.stack.imgur.com/xfKbT.png" alt="Picture of my Spreadsheet"></p>