How to custom format cells to check the difference between theme in excel
<p>I have three columns</p>

<pre><code>A|B|C
-----
4|3|2
4|4|5
4|5|6
5|3|2
5|4|4
5|5|6
5|6|8
</code></pre>

<p>I want to compare current column with previous and mark if it is less/equal/greater. I would like to use Icon condition formating so at the end the table should looks like this:</p>

<pre><code>A|B|C
-----
4|&lt;3|=3
4|=4|&gt;5
4|&gt;5|&lt;2
5|&lt;3|&gt;5
5|&lt;4|=4
5|=5|&gt;6
5|&gt;6|&lt;2
</code></pre>

<p>Now I have to create separate rule for each cell :( there must be a better way?</p>

<p>Here is what i have now:</p>

<p>one formula for each cell
<a href="https://i.stack.imgur.com/lsWuq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lsWuq.png" alt="one formating formula for each cell"></a>
<a href="https://i.stack.imgur.com/TajIE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TajIE.png" alt="formula details"></a></p>

<p>And now for column D I have to do the same :( New column will appear each week.</p>