Is it possible to sort by the fill-in color in Excel?  I do a lot of
highlighting rows, etc. and it would be so much easier than having to cut and
paste.

I am attempting to copy a formula and extend the data range and when I do,
the bradkets { } around the new formula vanish and the formula does not work.
I attempt to put the brackets in manually, and this does not work. What is
this?

Or how else could you do something like that?  I need a excel program to do
something similar to this:
=ROUND(IF(O60=TRUE,AVERAGE(P42:Q43),(IF(P58=P59,AVERAGE(P58:P59),P60),0

In the last year, whenever I use Excel 2000 spreadsheet, I key in a
number [eg:  500 creates 5.00].  I have attempted to change the cell
format to 'General' without success.  Changing to 'Number' brings the
same result except that the number is truncated [5].  This has become

Fairly large amounts of text pasted into cells.  All cells have text wrapped,
aligned left and centred and have adjusted row height and column width but
still can't see all text in some cells.  Does anyone know why this is
happening - particularly since it is not in all cells?

I have two workbooks, call them Workbook A and Workbook B. Workbook A is a
template that I use to track monthly sales, cash flow, etc. Each month I
simply plug in the new dates on each worksheet. Worksheet B is the current
month's report. I added a page with new formulas to the ...

I would like to modify the criteria in the database functions DMIN and DMAX
at the formula level, instead of by entering new value in criteria range cell.
I have a worksheet with the following structure:
PN       LOC

I have a spreadsheet I created to manage my pipeline of transactions.  I'd
like to create a cell in that spread sheet that contains the contact name it
goes with the transaction.  Is there a way to link that cell to the actual
contact record?

I have created a 3sheet work book which auto sums all my values required. I
need to be able to offer on the 1st work sheet the option to change text in a
cell and for that text to be mapped to the folloing 2 work sheets.
Example these are room names which could change according ...

Is there a way to select a range, and then SUM only the odd # rows in that
range?  Or, even # rows?
thnx so much

would like to merge data from one workwheet into another and combine the
data.  Both WS have a account # as one the column.  Would like all the data
associated with Acc# 123 in WS 1 to combine with all the data in WS 2 for
Acc# 123 to merge.

I have 2 work sheets. On worksheet XX1, I have put formula in cell C1 as
MAX(...) where I am getting value of cell C8 of worksheet XX2. Now based on
this C8 of XX2, I want to put C6 of XX2 at C2 of XX1.
I am not getting anything.. I tried to multiplex many formula's but could

I need to find out how I can flag or color a cell, such as
If cell B is less than Cell A I need to flag the cell that is less than cell
A.
The goal here is to flag all the cells that are less than another cell.

I want the maximum of column A when column B contains a certain word.  I tried
=max(A:A*(B:B="word"))
but get 0.  Thinking that the B reference was the problem, I tried
=max(B:B="word")

I have developed a worksheet that I would like to use on a daily basis to
pull numbers from a file that comes out with an updated version each day.  I
would like to use the same spreadsheet (by either copying and pasting the tab
into the updated s/s or pasting the updated tab ...