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
Please share it with me
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
Yes please
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
[Uploaded an Excel file]
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
I sent you one excel sheet please download and check
Excelchat Expert
05/08/2018 - 12:19
FYI
[Uploaded an Excel file]
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
Please extend the time
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
Please send me the excel
Excelchat Expert
05/08/2018 - 12:29
thats not google sheet
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
It doesn't seem to want to paste in google sheet, I'm now uploading the spreadsheet
Excelchat Expert
05/08/2018 - 12:31
ok
User
05/08/2018 - 12:31
Have you received it?
[Uploaded an Excel file]
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
I got your shet
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
please extend the time
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
[Uploaded an Excel file]
Excelchat Expert
05/08/2018 - 12:55
Just download this sheet and check
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
Thank you for your help. I really appreciate your time.
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.