Google Spreadsheets custom conditional formatting based on previous cell in same column
<p>I have a list of statistics I keep for my website ordered by type of stat (in columns) and month (in rows). So I'll haven for example:</p>

<pre><code>+---+-----+----------+-----------------+-----------+
|   |  A  |    B     |        C        |     D     |
+---+-----+----------+-----------------+-----------+
| 1 | /   | Sessions | Unique Visitors | Pageviews |
| 2 | Jan | 20000    | 15000           | 35000     |
| 3 | Feb | 21000    | 15500           | 36000     |
+---+-----+----------+-----------------+-----------+
</code></pre>

<p>I'd like to create two rules:</p>

<ul>
<li>one to color green each cell that has a higher value than the cell above it in the same column</li>
<li>one to color red each cell that has a lower value than the cell above it in the same column.</li>
</ul>

<p>Basically, I want to track improvements/declines from month to month.
I've found this thread:
<a href="https://stackoverflow.com/questions/17419835/conditional-formatting-based-on-previous-cell-value">Conditional Formatting based on previous cell value</a>
but it doesn't help me do what I want :/</p>

<p>I just want to be able to say, for example, if B4 is bigger than B3, color green, but if B4 is smaller than B3, then color red.</p>

<p>If anybody could let me know how to do this, I'd very much appreciate it, thanks :-)</p>