I create several charts to compare various volumes of data. Presently, if the
data is negative, I manually change the color of the bars to Orange. I would
like to write a conditional statement to automate this.
Any help is greatly appreciated.

I have one sheet that contains info for all three office locations. One
column on this sheet contains location ID. I want to create three seperate
sheets for each office, then have a formula that will copy the info from a
row on the primary sheet to respective office sheet. ...

I am making a spreadsheet of all of our products and all of the options
(colors, mounting, options, etc) my sheet already contains about 15,000 rows,
and i need to A) create 5 blank rows below EVERY row B) for every row i put 5
rows under, i need to copy and paste into those 5 ...

formula for percentage is minus sign. Why?

I am doing a project in Excel and the instructions are to copy all
information on the data worksheet on the Ascending by LName worksheet? I can
not find this worksheet and need some help????

My document has a page break after every row, don't know how they got there
or why? This document should fit on 1 page if I go to setup and tell excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to size to
10% and then tells me margins will not it on page.  ...

I don't know if I am in the right group, so I will post here and not
cross post.
I have several functions that I need to set up a Custom Menu for. This
is my first time exploring this type of feature and could use your

I have a nifty sheet that does some automated play calling for a game, and
it works fine if I just select a cell (empty one) and hit delete - it
re-randomises and picks a play
however, I tried adding a button and code to make it a clickable button, but

I have got something like:
=IF(OR(AND(J3>B3,J3<C3),(AND(J3>E3,J3<F3)),(AND(J3>H3,J3<I3)),TRUE,FALSE))
In words, I am trying to say:
IF the value in X is greater than a, AND less than b, OR greater

Hello Excel Gurus,
I have a spreadsheet containing a column of 100 items. I want to change from the
original ordered state to a randomized state. One way would be to create a
randomized column of numbers from 1 to 100 in an adjacent column, such that no

I have a column of numbers and I need to add a dash between the first two
numbers without having to do it manually (several thousand rows).  Is it
possible?

My Excel files contain identifying words or symbols in a column. How can I
sort to bring the desired rows to the top if the charcater or word is not the
first one on the cell? I use Microsoft Office 2003 on XP.

In A1:L1 I have January through December
In A2:L2 I have --
200 -- A2
0  -- B2

I am looking for a formula to do the following:
If any cells in Column C = B2, Then average the corresponding cells i
Column J...
I was thinkin

I have two ranges of data with the same headings.  One range will
continuously have data added to it each month, where the other is a
static row of data that gets changed each month.  I need to pivot both
ranges together but i dont want to add in the static data to the