Quickly defining functions and Buttons

[RexMan85]

1. I want to set a function for a spot, like this: =E11+D11/G11
And I want to do it from 11 to 100. is there a way to do it fast?

2. I want to have a simple button that will add 1 to a spot, How can I do it?

[alansidman]

1. In what column do you want this formula?

2. I have no idea what you are asking here. Please try again with more details. By spot, are you referring to a specifc cell. I don't know what a spot is.

[oeldere]

I don't know either the word spot.

Did you try do drag down the formula.

It will change E11 in E12 and so on.

Or this in not what you trying to achieve?

[RexMan85]

1. In what column do you want this formula?

2. I have no idea what you are asking here. Please try again with more details. By spot, are you referring to a specifc cell. I don't know what a spot is.

1. What do you mean?

2.If cell E11 has "13" in it, I want to be able to press something to make it "14",

3. Also, if I have a list of numbers, How can I change their color based on their order (green will be the highest value, red will be the lowest value...)

[oeldere]

post an exemple of your excel file, wihtout confidential information.

please also add the desired result.

[alansidman]

Here is number 2.

Insert a command button on your spreadsheet. Attach this code to it.

Activecell.value = activecell.value +1