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.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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
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,823
Office Version
2013
Platform
Windows
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,823
Office Version
2013
Platform
Windows
deleted - my suggestion failed
 
Last edited:

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,971
Messages
5,508,470
Members
408,687
Latest member
KevinNTU

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top