How can I get the formatting to sort along with the text?  i.e. borders,
shading, etc.

I am trying to add sales gross for individual salespeople, and break it down
by new vehicles vs. used vehicles.    I have a column set up for the sales
people, a column set up for the type (N or U), and a column set up for the
gross that I want to add.  I can make it add up the ...

I'm sure that this is a no-brainer for most of you, so that is why I am
posting in this forum.
I am trying to fill in cells in a worksheet using an IF..AND statement,
but it's not working properly, so I'm obviously doing something wrong.

I am looking up values in a Pivot Table.  If the value is null, the formula
is displaying zero instead of null.  Is there a way to display null when null
and zero when the value is zero?

I am trying to get a comment to appear across several rows on an Excel
worksheet, vertically. I have tried everything in the Format option of the
menu, but it just won't appear without making the row the size of the
comment. I want it to print across the rows that there is ...

Need to know how to copy linked cells from one worksheet to another without
having to manually change the cell number in the new worksheet. E.G. sheet
named July 2006 has linked cells $F$19 and need to change on August worksheet
to $G$19. Is this possible?

I've got a workbook with several sheets that all have pretty much the same
list of spare parts on them that are all linked together somehow by formulas.
If I change the cell color on the master list I want the cell color to
change on all the lists.  For example part A is overdue ...

i have 5 worksheets in a book that i reference.Each worksheet has a name.I
have bowling scores for each person .when i do a search to find who has the
high score i can get that result no problem.It will give me a result 298
which turns out right.

At the university i got an assignment on how to perform the gaussian
elimination by using excel. i tried so hard...but was unable to find
something useful. Could somebody explain...ot give me a list of
formulae..

I have a list of names/accounts, in front of each there's a check-box which
tells if the account was completed or not (checked or cleared - false or
true). How can I count the total of checked and/or unchecked check boxes?
Thank you

I maintain some data in an Excel workbook as follows. It consists of 18
columns by some 3636 lines of data. We make use of Excel to maintain and
publish the given dataset, primarily because of the general familiarity and
competency of all staff concerned. The data is nothing ...

Hi guys... I have a similiar query.... plzzzz can someone help me!
I'm constructing a spreadsheet to work out the difference in time and date;
A1                         A2                      A3
07/11/04 11:00     04/11/04 10:00    3:1:00 (d:h:mm)

I need to show a bitmap only if (for example) cell A1 = 1 but not if A1 = 0.
Is this possible using conditional formatting or other method?
Thanks

What I have is a worksheet with the details ie. job no, client etc. I
basically have eleven Header colums. I then have 2000+ rows with job
numbers and clients, this already has a macros to copy them into a
invoice on sheet 2.

This is only part of what I need -
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Sheet name is 30 (for the day of the month) Every month has a separate file
and it has a sheet for every day of the month.