Positive/Negative Change indication

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
My apologies if I become slightly annoying in the next couple of weeks, but after two years of learning Excel VBA I've come to the realization that I do not know JACK about excel. :(

My question...

Lets say I have two columns A & B and I'd like to indicate the direction (More/Less) Column B moved from column A. If the change was positive between A and B I'd like to have an UP arrow on the right side of column B and a DOWN arrow if the change was negative.

Is this something that would be accomplished with Conditional Formating and Shape insertion? I don't want to change the arrow manually when the data changes. Kind of like you see in some accounting software.

Thanks.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

gauntletxg

Well-known Member
Joined
Jul 15, 2008
Messages
636
If you make the font of column C Wingdings 3, you could do something like this

Excel Workbook
ABC
11001505
2100506
Sheet1
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
Code:
=IF(B3=A3,1,IF(B3<A3,"i","h"))
(formatted as Wingdings 3)

You can use conditional formatting to change the colour.
 

Flue

Board Regular
Joined
Feb 5, 2009
Messages
106
Cool thanks.

Pretty sure it's not possible, but you cannot combine two font styles in a single cell, correct?
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764

ADVERTISEMENT

Cool thanks.

Pretty sure it's not possible, but you cannot combine two font styles in a single cell, correct?

You can if the cell only contains text, but not if it contains a formula (I think).
 

James_Latimer

Active Member
Joined
Jan 20, 2009
Messages
415
that is correct, you can format any part of text when the cell contains text alone, if there is any form of formula in there then the answer is no.
 

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,893
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

If you are using 2007 it has a selection of arrows in the conditional formatting. Unfortunately it appears on the left of the number.
(in the same cell)

I don't know whether this is applicable to other versions Excel.

So 2 rows A and B and B shows changes

Select the Cell B.
Select Conditional formatting/New Rule

Leave as first rule highlighted. 'Format all cells based on value'

In format style select Icon Sets.
Select 3 Arrows coloured from the Icon Style drop down

In both the Type drop downs select formula.


For the green arrow select > and in the value =$A$2
For the yellow arrow select >= and in the value =$A$2

Ok then OK
 
Last edited:

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,893
Office Version
  1. 2013
Platform
  1. Windows
deleted - my suggestion failed
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,133,322
Messages
5,658,143
Members
418,429
Latest member
Regila

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top