# Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

In excel how do I activate an object based on a value from a cell. I'm wanting an arrow to appear based on a value in a cell that has been returned from the sum (formula) of a range of cells. I'm trying to teach myself to code and I'm very much at the beginning stage
Solved by F. A. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 05/08/2018 - 01:10
Hi there
User 05/08/2018 - 01:10
Do you use the developer tool in excel?
User 05/08/2018 - 01:11
Developer is an add-on so you can code and build macros
Excelchat Expert 05/08/2018 - 01:11
Developer tool in excel are used on for macros.
Excelchat Expert 05/08/2018 - 01:11
That;s right.
Excelchat Expert 05/08/2018 - 01:12
To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu. When the Excel Options window appears, click on the Customize Ribbon option on the left. Click on the Developer checkbox under the list of Main Tabs on the right. Then click on the OK button.
User 05/08/2018 - 01:12
Yes, I havfe done all of this
User 05/08/2018 - 01:12
What I need to know is how to get a custom shape to appear when a value has been returned in a cell from a calculation of numbers over a range of cells
Excelchat Expert 05/08/2018 - 01:12
So buddy you want to input some object on cell?
User 05/08/2018 - 01:13
I'll upload the spreadsheet so you can see what I have been working on, is that ok?
User 05/08/2018 - 01:14
Did you receive this?
[Uploaded an Excel file]
Excelchat Expert 05/08/2018 - 01:14
Sure buddy.
User 05/08/2018 - 01:15
When a value appears, like in column "F", I want a custom arrow (red) to appear alongside the corresponding graph (image). How do I get this to work?
User 05/08/2018 - 01:16
I know how to get the arrows to appear and disappear using code, but I don't know how to do this based on a value (or range of values), that appear in a cell
Excelchat Expert 05/08/2018 - 01:16
Let me check dear.
Excelchat Expert 05/08/2018 - 01:18
Is the result is what band is?
User 05/08/2018 - 01:22
Yes
User 05/08/2018 - 01:22
So the arrow will appear alongside the corresponding band, reflecting that number
Excelchat Expert 05/08/2018 - 01:23
Do you like to do it by If function?
User 05/08/2018 - 01:23
An arrow represents a range of numbers
Excelchat Expert 05/08/2018 - 01:23
Do you know how to make it arrow up and down.
Excelchat Expert 05/08/2018 - 01:24
Its sound its VBA topics.
User 05/08/2018 - 01:24
I know how to use conditional formatting, if that's what you mean
Excelchat Expert 05/08/2018 - 01:24
Yes.
User 05/08/2018 - 01:24
That isn't what I'm looking for
Excelchat Expert 05/08/2018 - 01:24
Conditional formatting.
User 05/08/2018 - 01:24
Yes, it will fall under vba
Excelchat Expert 05/08/2018 - 01:24
Can you please elaborate .
Excelchat Expert 05/08/2018 - 01:25
But subjects here for now is excel and VBA.
Excelchat Expert 05/08/2018 - 01:25
Passed on Excel.
User 05/08/2018 - 01:25
It has to be a code written to get the custom shape to appear and disappear based on a value from a cell
Excelchat Expert 05/08/2018 - 01:25
Do you have any idea about VBA/
User 05/08/2018 - 01:26
I have some very basic understanding
Excelchat Expert 05/08/2018 - 01:26
Yes but how did ou insert that arrow up and down based on criteria?
Excelchat Expert 05/08/2018 - 01:26
Let me know so that I learned too.
User 05/08/2018 - 01:26
I have been teaching myself by using on-line tutorials
Excelchat Expert 05/08/2018 - 01:26
YEs like UDEMY.com.
Excelchat Expert 05/08/2018 - 01:27
You can extend time by 20 mins here.
Excelchat Expert 05/08/2018 - 01:27
So lets be consider your topics.
User 05/08/2018 - 01:27
So, I'm assuming you can't help me at this point in time?
Excelchat Expert 05/08/2018 - 01:28
I noticed that based on value of F column change the arrow up and down.
Excelchat Expert 05/08/2018 - 01:28
Try my best.
User 05/08/2018 - 01:28
Thanks for your assistance, I appreciated your time.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at