title: Multi-column vlookup conditional formatting
body: <p>I'm looking to create a conditional format for a worksheet based on a couple of things.</p>
  
  <p>Sheet 1:</p>
  
  <p>Reference: "Date" = Col1 Row1</p>
  
  <pre><code>    Date    Census          RN's On Schedule                
              7a  3p  11p     7a  3p  11p     
      1-Oct   8   8   9       8   8   9       
      2-Oct   10  14  13      13  16  13      
      3-Oct   10  12  12      12  12  10      
      4-Oct   12  10  10      11  11  10      
      5-Oct   10  11  11      11  12  11      
      6-Oct   10  11  14      11  12  12      
      7-Oct   13  12  12      12  14  12      
  </code></pre>
  
  <p>Sheet 2:</p>
  
  <p>Reference: "Census" = Col1 Row1</p>
  
  <pre><code>Census  RN Staffing Needs       
          7a  3p  11p     
  1       2   2   2       
  2       2   2   2       
  3       2   2   2       
  4       3   3   2       
  5       4   4   3       
  6       4.5 5   5       
  7       5   6   6       
  8       6   7   6.5     
  9       7   8   7       
  10      8.5 9   8.5     
  11      10  11  10      
  12      12  12  11.5    
  13      12  12  12      
  14      12  12  12      
  15      13  13  13      
  16      13  13  13      
  17      14  14  14      
  18      14  14  14      
  </code></pre>
  
  <p>So here's the question.</p>
  
  <p>I've got these values in sheet 1 that I'm looking to compare to sheet 2 and use conditional formatting to highlight certain things.  I need excel to look at the census (for reference, 1-Oct census is 8 @ 7a) from sheet one and find it in sheet two.  Then I need it to compare the number in <strong>RN's On Schedule</strong> to the number in <strong>RN Staffing Needs</strong> (RN Staffing Needs, in this case 6 @ 7a; RN's On Schedule, 8).  When the RN's on Schedule value from Sheet 1 (F3 in the case of 1-Oct) is HIGHER than the RN Staffing Needs from Sheet 2 I need a conditional format to highlight that value green.  When it is LOWER I need it to highlight that value yellow.  When there is an exact match nothing needs to happen. </p>
  
  <p>I've tried vlookups and index/matches with nested IF statements and IFERROR's and the like... this one's a little out of my scope of practice.  Any help will be greatly appreciated!!</p>