Is there a way to sot based on the color of the text or by the background
color?
I have a spreadsheet that the background is changed based on the status of a
shipment and we would like to be able to sort by the color.

I know that the first response to my question is going to be "DO NOT use
merged cells!!"  
However, with that being said, is there any workaround to linking a merged
cell (b1-b2) from sheet 2 to a merged cell (a1-a3) on sheet 1?  

I am setting up a bank account project with 12 worksheets, one for each
month.  I know that it is possible to find the sum of a specific cell
thoughout all of the worksheets (=SUM('Jan:Dec'!D4).  I am trying to
apply this same principle to the MATCH function.

just getting back into excel formulas... this is probally an eas
question....
i basically have a collumn full of account numbers that represen
numeric strings....

I want to do a dynamic change for $R$C of link reference so that it is
pointing to a differenct location without having to do Find & Replace.
Something like back single quote when you are doing shell scripting.

I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38).  Do you use the IF function or is there another way to do
it?  What is the IF function syntax?

I have a range of cells that I need to reference.  This range always
starts at B23 and goes to B??? (the last row will be different each
time we open the file and load data).  What I want to be able to do is
enter the number of the last row of this range in B1 and then

I am trying to replace all of the numbers in a spread sheet with text or XXX.
if this is posible let me know

I know there is a way to get a sum of the all the values in, say, D4,
in all the worksheets of a workbook (=SUM('Jan:Dec'!D4)).  I want to
apply this principle to the MATCH function.
I am trying to set up a match function to search through a specific

I keep getting this problem and always find very hard to overcom
without loosing much time and efforts. I have one spreadsheet A wit
vlookup formulas that are supposed to retrieve the info I want (prices
which are located in another spredsheet (B). The idea is to insert

I would like to be able to show number of days in seperate columns. Using
dates as values.
e.g. column 1= # of days between 1 & 31, column 2= # 0f days between 1 & 60.
and so on!

I have a workbook that has 31 pages in it for each day in a month.
have multiple companies that I make either a delivery or a drop off fo
each day. I want to be able to have one page that will compile b
company how many deliveries or pickups each company made for the month

'Public Function DisplayCellFunction(cellID1 As String, cellID2 As String)
Public Function DisplayCellFunction(cellID1 As Integer, cellID2 As Integer)
   'Copy formulas to the adjacent cell for visual verification
   'Range(cellID1) = "'" & Range(cellID2).Formula

The outcome of a calaculation in my excel worksheet is #deel/0! ( in Dutch ).
I want to make the calculation and were it says #deel/0! i want to replace it
by another value.
Can you help me how to do this in Excel