**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.*