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 I. S. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 05/08/2018 - 12:09
Hi
Excelchat Expert 05/08/2018 - 12:09
Welcome to Got it Pro
User 05/08/2018 - 12:09
Thanks
Excelchat Expert 05/08/2018 - 12:09
do you have any excel sheet?
User 05/08/2018 - 12:10
i'm working on one, yes
Excelchat Expert 05/08/2018 - 12:10
Excelchat Expert 05/08/2018 - 12:10
and explain your criteria for arrows
Excelchat Expert 05/08/2018 - 12:11
Are you there?
User 05/08/2018 - 12:12
Yes, I don't have a spreadsheet that I can share that shows my problem
User 05/08/2018 - 12:12
Is there some simple code to be able to get an arrow to appear when a formula calculates a number?
Excelchat Expert 05/08/2018 - 12:13
ok fine.
Excelchat Expert 05/08/2018 - 12:13
let me work on it and share you the result
Excelchat Expert 05/08/2018 - 12:13
Is this fine
User 05/08/2018 - 12:13
For example, if a cell calculates the total "6" from a range of cells, will the value of 6 trigger the activation of the arrow to appear?
User 05/08/2018 - 12:14
User 05/08/2018 - 12:15
Yes, so F1:8 are the tallies of the preceding rows
Excelchat Expert 05/08/2018 - 12:15
yes
User 05/08/2018 - 12:15
What happens now?
Excelchat Expert 05/08/2018 - 12:16
One minute
Excelchat Expert 05/08/2018 - 12:16
I wills share the excel file
Excelchat Expert 05/08/2018 - 12:16
FYI
Excelchat Expert 05/08/2018 - 12:17
I just sent you the excel sheet please check and confirm
User 05/08/2018 - 12:17
Yes, I have it
Excelchat Expert 05/08/2018 - 12:18
Ok.. Are you able to see the icons based on the Total Value
Excelchat Expert 05/08/2018 - 12:18
with different colors
User 05/08/2018 - 12:18
Yes
User 05/08/2018 - 12:18
Yes
Excelchat Expert 05/08/2018 - 12:18
Is it fine...
User 05/08/2018 - 12:18
At teh moment they are all gree
Excelchat Expert 05/08/2018 - 12:18
No.
Excelchat Expert 05/08/2018 - 12:19
Dont look at the google sheet
User 05/08/2018 - 12:19
They have all disappeared now
Excelchat Expert 05/08/2018 - 12:19
Excelchat Expert 05/08/2018 - 12:19
FYI
User 05/08/2018 - 12:19
Yes, sorry, I have it open now.
Excelchat Expert 05/08/2018 - 12:20
No issues
User 05/08/2018 - 12:20
I can see the conditional formatting in each row alongside the tally
Excelchat Expert 05/08/2018 - 12:21
yes...
User 05/08/2018 - 12:21
but I'm looking for an inserted arrow as an object
Excelchat Expert 05/08/2018 - 12:21
Oh ok...
Excelchat Expert 05/08/2018 - 12:21
Give me two minutes please extend the time
User 05/08/2018 - 12:21
How do I do that?
Excelchat Expert 05/08/2018 - 12:22
It will ask you to do close to three minutes
User 05/08/2018 - 12:23
will there be an option to extend beyond?
User 05/08/2018 - 12:25
are you there?
Excelchat Expert 05/08/2018 - 12:25
yes
Excelchat Expert 05/08/2018 - 12:25
Excelchat Expert 05/08/2018 - 12:25
Ya got it
User 05/08/2018 - 12:25
I've extended the time
Excelchat Expert 05/08/2018 - 12:25
for object first you have to insert the arrows
Excelchat Expert 05/08/2018 - 12:25
then you have to change the colors based on the value
Excelchat Expert 05/08/2018 - 12:25
it will not automatically come
User 05/08/2018 - 12:28
Can you see the graph that I have added?
User 05/08/2018 - 12:28
and the rows that I have added?
Excelchat Expert 05/08/2018 - 12:28
No
Excelchat Expert 05/08/2018 - 12:28
I am not able to see anything
User 05/08/2018 - 12:28
I have placed them in the same spreadsheet that you sent me. Is that no longer working?
User 05/08/2018 - 12:29
I'm wanting a different arrowl to appear for each number that appears
Excelchat Expert 05/08/2018 - 12:29
Excelchat Expert 05/08/2018 - 12:29
User 05/08/2018 - 12:29
Is it better to paste it in google sheet?
Excelchat Expert 05/08/2018 - 12:30
ok
Excelchat Expert 05/08/2018 - 12:30
paste it
User 05/08/2018 - 12:30
Excelchat Expert 05/08/2018 - 12:31
ok
User 05/08/2018 - 12:31
Excelchat Expert 05/08/2018 - 12:32
yes
Excelchat Expert 05/08/2018 - 12:32
one minute let me open the sheet
User 05/08/2018 - 12:32
ok
User 05/08/2018 - 12:33
I have worked out how to get an arrow to appear and disappear using coding, but I don't know how to do this based on a value from a cell
Excelchat Expert 05/08/2018 - 12:34
coding?
User 05/08/2018 - 12:34
Yes, vba
User 05/08/2018 - 12:34
using the developer tool
Excelchat Expert 05/08/2018 - 12:34
Excelchat Expert 05/08/2018 - 12:34
*sheet
Excelchat Expert 05/08/2018 - 12:35
you have highlighed in red arrow
Excelchat Expert 05/08/2018 - 12:35
We will not support VBA
User 05/08/2018 - 12:35
I'm confused
Excelchat Expert 05/08/2018 - 12:35
I will do it now and send you
User 05/08/2018 - 12:35
It is in excel
User 05/08/2018 - 12:36
What do you mean you don't support vba???
Excelchat Expert 05/08/2018 - 12:37
We will not support VBA only excel formulas
User 05/08/2018 - 12:38
but the developer is part of excel, how can you not support it. Does this mean you can't help me?
Excelchat Expert 05/08/2018 - 12:38
Are you expecting using VBA coding?
User 05/08/2018 - 12:38
I'm using the coding that the on-line tutorials for excel tell you to use
User 05/08/2018 - 12:38
I was of the understanding it is vba
Excelchat Expert 05/08/2018 - 12:39
oh ok.
Excelchat Expert 05/08/2018 - 12:39
will use custom shapes for your case
User 05/08/2018 - 12:40
Yes
User 05/08/2018 - 12:40
That's what the arrow is, a custom shape
Excelchat Expert 05/08/2018 - 12:40
wait...two minute
User 05/08/2018 - 12:40
ok
Excelchat Expert 05/08/2018 - 12:44
Going to finish
Excelchat Expert 05/08/2018 - 12:44
User 05/08/2018 - 12:45
What do you mean?
User 05/08/2018 - 12:45
Yes, sorry I have extended the time
User 05/08/2018 - 12:51
Are you still there?
Excelchat Expert 05/08/2018 - 12:53
yes
Excelchat Expert 05/08/2018 - 12:53
but for arrow its not coming
Excelchat Expert 05/08/2018 - 12:53
only square shapes its coming
User 05/08/2018 - 12:53
I'm not sure what you mean?
Excelchat Expert 05/08/2018 - 12:55
FYI
Excelchat Expert 05/08/2018 - 12:55
Excelchat Expert 05/08/2018 - 12:56
There are two sheets
User 05/08/2018 - 12:57
I've received the sheet and I can see the table
User 05/08/2018 - 12:57
I can see the data chart as well
Excelchat Expert 05/08/2018 - 12:57
yes
Excelchat Expert 05/08/2018 - 12:57
This is how we can do the custom shapes
User 05/08/2018 - 12:58
How do i use the score to have a custom shape, like an arrow, appear
User 05/08/2018 - 12:59
All I want to do is get an image to appear and disappear from the value of an integer
Excelchat Expert 05/08/2018 - 12:59
No it is not possibel
Excelchat Expert 05/08/2018 - 12:59
image is it?
Excelchat Expert 05/08/2018 - 12:59
ok one minute will tell you another method
User 05/08/2018 - 01:00
I know it is possible, but it is just needs a specific code. It will be based on a range of numbers, I'm just not sure how to write the code.
User 05/08/2018 - 01:00
Excelchat Expert 05/08/2018 - 01:00
give me two minutes
Excelchat Expert 05/08/2018 - 01:01
I will give you another method
User 05/08/2018 - 01:01
Do you use the developer add-on in excel?
User 05/08/2018 - 01:02
Is there a way I can be passed on to someone who uses the developer tool?
Excelchat Expert 05/08/2018 - 01:05
No.
Excelchat Expert 05/08/2018 - 01:05
We are not authorized to use VBA
Excelchat Expert 05/08/2018 - 01:05
Sorry for the inconvenience
Excelchat Expert 05/08/2018 - 01:05
Our system itself will not allow us to generate the code
User 05/08/2018 - 01:05
No problem, I really appreciate your time. Thank you once again!
Excelchat Expert 05/08/2018 - 01:06
Thanks for your patience and please connect with us again for any excel queries not excel vba queries

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.