title: Conditional Formatting of a value based on Yes or NO
body: <p>I have two ROWS, one has values and the other <code>Yes</code> or <code>NO</code>. I want the values in ROW 1 to be colored according to whether <code>Yes</code> or <code>NO</code> in ROW 2 in the corresponding column. For example:  </p>
  
  <pre>
     ROW 1  XXXX|XXXX|XXX|XXXX  
     ROW 2  YES | NO |YES| NO</pre>  
  
  <p>There are no conditions to why ROW 1 should be yes or no, it's just the way it is.  </p>
  
  <p>Is it possible?</p>