Can you help me with the following sytuation               
I have data in sheet1 in a vertical order               
Sheet1               
A    B    C    D   

I have a workbook with about 125 tabs/sheets - each tab/sheet with several
columns that are summarized at the bottom, and then those summarized numbers
are linked to a main "summary" page.  I noticed today that when I changed
numbers in any of the columns in any of the sheets, ...

I would like to set up a spreadsheet of data so that if anything is modified
in a cell, the entire row changes color.  Is this possible in Excel and if
so, how can it be done.  I have tried the "track changes" but that does not
change the background color, it marks the cell.  ...

Ive been block out for this one task of checking results from the huge
workbooks from different departments...full of stress and pressure...
here's my data from Row 2..
COL A    COL B    COL C    COL D

in my formulation list workbook, i have one column filled with different
formulas...
result can be a text, number, and all sorts of known error types....e.g.
#NULL!

Hello.  I am am looking at using a vlookup formula on a worksheet in 2007.  
It is listed below.  The "Rates" is the other worksheet that has the info in
to look up.  I am getting the #VALUE error message in the cell, whether I do
the cntrl + shift + enter or not.  

I have a spreadsheet that has three tables.  I need to create a lookup that
looks in the first table and if it doesn't find the value goes to the second
table and then the third to find the value.  What I have been using is
vlookup(a3,a10:k10,3,vlookup(a3,o10:y10,3,vlookup(a3,aa10 ...

can someone let me know why this formula is not working?
=SUMPRODUCT(--('Budget Dec 07'!A3:A19=Report!B9),--('Budget Dec
07'!I1:T1=6),'Budget Dec 07'!I3:T19)

I need to be able to round the sum of a formula to the nearest quarter hour,
such as:
This is my formula
=C4-E4-(D4*G4)

Below is my formula...there are #DIV/0! in the data set...(I can't remove).  
I want to exclude them in the formula.  Basically...how to I exclude the
#DIV/0! in the following formula?  Thanks in advance...
=(SUMPRODUCT((Main!$H$2:$H$95>100)*(Main!$I$2:$I$95-Main!$H$2 ...

My X axis values start at A8 (headings on the 7th row).  I have four series
one in each of columns C through F. (Column B has some misc. data).  # of
rows grows as data is added.
I have succesfully used named formulas in the past when I had one X axis in

I have an excel sheet and I need to clean out all non-letter
characters and keep only a-z, how do I do that?

Is there any way of flagging blank cells within a spreadsheet?
Normally when one of the cells within any one row is populated, there are
additional cells in that same row that also needs to be populated in order
for the calculations/formulas on subsequent worksheets to work.

I have created a pivot table in Excel 2007 that sums of dollar and unit sales
for two time periods and then I have created formulas in the pivot table to
calculate average price for the two time periods.
I now want to set up conditional formatting based on the average price for

In cells DZ4:EG4, I have some numbers.  In EH4 I would like to enter a
formula which checks if all the numbers shown match each other, i.e. if they
are consistent across the board.  
If the numbers match, I'd like to show True.  If one or more of the figures