Anyone who pays a programmer by the hour is not overly bright!<bg>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Biff" <biffinpitt@comcast.net> wrote in message
news:%232fk$idkGHA.4200@TK2MSFTNGP05.phx.gbl...
> I've spent hours, yes hours, attempting to do just 3 simple things.

One of the advantages of getting paid by the hour! <bg>

Sorry, I couldn't resist!

See the reply by Ardus for productive solutions.

Biff

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:5B4F0959-D013-4870-B3F4-7A16D0ACB075@microsoft.com...
> 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
>
>
>