title: Change background color of the row or range if a particular cell value is equal to some text
body: <p>What I have:</p>
  
  <pre><code>1   Col A      Col B  Col C   Col D   Col E  Col F 
  2
  3  Approved    Text   Text    Text    Text   Text
  4  Reject      Text   Text    Text    Text   Text
  5  Pending     Text   Text    Text    Text   Text
  </code></pre>
  
  <p>What I want is :</p>
  
  <ol>
  <li>If Column A value is equal to <code>Approved</code> then entire <code>row-3</code> should have a <code>green</code> background.</li>
  <li>If Column A value is equal to <code>Reject</code> then entire <code>row-4</code> should have a <code>red</code> background.</li>
  <li>If Column A value is equal to <code>Pending</code> then entire <code>row-5</code> should have a <code>amber</code> background.</li>
  </ol>
  
  <p>How to change the background color of the row or range if a particular cell value is equal to some text?</p>