C
Chris
Ok I've spent hours, yes hours, attempting to do just 3 simple things. Well
they sound simple but hopefully they actually are simple. I've looked
through ALL the functions in excel and could not find hat i'm looking for.
The first thing I want to do it is set multiple cells equalling to a seperate
cell. Now theres a way to do this indivudually but if you click and drag the
result to other cells it doesn't retain the box you want, it gives box's in
ascending order. For example, I want D-17 with a value of lets say 5 to equal
ten different cells. So i left click my first cell hit "=" then click cell
D-17. This cell now equals whatever content is in D-17, in this example its
5. I drag this cell to 10 cells below it and they all don't equal D-17, they
equal D-18,D-19,D-20 etc..... Is there a way to assign multiple cells to a
single box?
Another question I have which probably took me the longest amount of effort
of research was: Let's say I have a few columns. If someone is filling in
these columns and a value of one the cells is greater than 5 lets say, the
number that they entered turns red or any other color. I can't figure out
how to do this. Anyone have an idea.?
My last question that I have is lets say I have a List Box. Someone can
click a cell and a list drops down and that person can select a particular
option. Now lets say they select 1 out of 10 of the choices. I want to assign
a value to a seperate cell depending on what option is picked. So lets say
Hamburger is picked out of pizza, fries, icecream, etc., I want a new cell to
be linked to this that has a value of lets say 3.95. I got it working with an
if statement but the if statement only gives me two options, i need 10. Any
ideas?
I appreciate any and all help. Its kinda silly that once you know something
it can be repeated in 10 seconds. but if you don't know how to do the little
easy tricks it can take hours and hours to figure them out. Thanks a lot guys
they sound simple but hopefully they actually are simple. I've looked
through ALL the functions in excel and could not find hat i'm looking for.
The first thing I want to do it is set multiple cells equalling to a seperate
cell. Now theres a way to do this indivudually but if you click and drag the
result to other cells it doesn't retain the box you want, it gives box's in
ascending order. For example, I want D-17 with a value of lets say 5 to equal
ten different cells. So i left click my first cell hit "=" then click cell
D-17. This cell now equals whatever content is in D-17, in this example its
5. I drag this cell to 10 cells below it and they all don't equal D-17, they
equal D-18,D-19,D-20 etc..... Is there a way to assign multiple cells to a
single box?
Another question I have which probably took me the longest amount of effort
of research was: Let's say I have a few columns. If someone is filling in
these columns and a value of one the cells is greater than 5 lets say, the
number that they entered turns red or any other color. I can't figure out
how to do this. Anyone have an idea.?
My last question that I have is lets say I have a List Box. Someone can
click a cell and a list drops down and that person can select a particular
option. Now lets say they select 1 out of 10 of the choices. I want to assign
a value to a seperate cell depending on what option is picked. So lets say
Hamburger is picked out of pizza, fries, icecream, etc., I want a new cell to
be linked to this that has a value of lets say 3.95. I got it working with an
if statement but the if statement only gives me two options, i need 10. Any
ideas?
I appreciate any and all help. Its kinda silly that once you know something
it can be repeated in 10 seconds. but if you don't know how to do the little
easy tricks it can take hours and hours to figure them out. Thanks a lot guys