Up and Down arrow (and =) indicator when the value is more or less than the previous cell

newbiecel

New Member
Joined
May 24, 2019
Messages
5
Hi

I have a row of test scores and I would like to show in the same cell next to the score an arrow that points up if the score is higher than the previous cell and an arrow pointing down if it's less. If the score is the same either an = or nothing.

Can this be achieved with conditional formatting?

Thanks

Gibby
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
17,958
Office Version
2013
Platform
Windows
More likely be able to do it in an adjacent cell, but not the same cell...!!!
 

ClaireS

Board Regular
Joined
Jul 29, 2013
Messages
136
Not that I can see: you cannot use cell references in icon set conditional formats. I would put it in the next column, base the formatting on a formula that subtracts the number from the one above, using an up arrow for positive numbers, horizontal (or blank) for a zero difference and a down arrow for negative values. You can show just the icon, so the difference values are hidden.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,213
Office Version
365
Platform
Windows
Something like
<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>G</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">? 2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">? 3</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;">? 1</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;">? 2</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;">? 4</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;">? 7</td></tr></tbody></table><p style="width:3.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Data</p><br /><br />

Select G4:G9 & use
=G4<g3
& custom format ▼ ?0</g3
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,213
Office Version
365
Platform
Windows
The question marks in the table are infact either ▼ or ▲
 

Forum statistics

Threads
1,077,795
Messages
5,336,373
Members
399,077
Latest member
johnk94

Some videos you may like

This Week's Hot Topics

Top