Conditional Formatting based on date and value in Excel
<p>I am trying to return the color for a score based on the date for the score and the score itself. Scoring has used different cut-offs over time:</p>

<pre><code>Table 1
Date1   Score  Color
Sep-16   24    [should be red]
Jul-16   6     [should be green]
Apr-14   12    [should be yellow]
...      ...   ...

Table 2
Date2   Red Orange  Yellow  Green
Aug-16  20  15       9.5    0
Jul-16  20  15.5     9.5    0
Apr-16  20  15       9.5    0
Mar-15  19  14       7      0
Feb-15  20  13       8.5    0
Jan-15  19  14       7      0
Apr-14  19  14       7      0
</code></pre>

<p>I want to place a formula in the "Color" cell that will evaluate Table 2 and return the column name for instances where the date in date1 is the most recent instance where it is greater than date 2, and for which the score given on table 1 is equal to or larger than the score given on table 2 for the correct row.</p>

<p>Thanks,</p>