In columns B through J I have percentages.  Is it possible to have the over
70% highlight in red and the under 30% highlight in blue?  Thanks.

I am using excel 2003
I have two separate spreadsheet tables that has mostly the same data though
there is some different data.  Is there a way that i can sort the data onto
one spreadsheet using similar indentifiers and separate the data that is not

I have an Excel database which contains one numeric column named
Price.  That Price column is formatted as "#,##0".  In other words, no
decimal places.
Drilling down through the Data menu, I run the MS Query Wizard, and on

Is there a a navigation option in Excel that allows you to double click on a
cell which then navigates to the precedent cell.  Where is this option
located?
Thanks

What is the use of calculation for Automatic except tables .
You can view this Tools -> Options -> Calculation tab.
Thanks
Vinod

I am having difficulty creating a reference lookup.
I need to be able to enter a place (which will be listed amongst hundreds in
Column A) and then get back and answer shows the values in the row from where
its found the place name and what column header each relates to

Hi, I am working on a very large work book and I am having a difficult time
solving an error.
I copied a worksheet to a new tab (this way if anything happened I can still
have the original sheet). The old tab subtotaled fine and I was able to drill

it can't compile, It appears to be the ws as object declaration.  How do I
declare ws?
tnx,
Private Sub UserForm_Initialize()

If I have a list of workbooks within a folder, is there any way to highlight
a name or add color to a name so that it stands out quickly from the rest of
the list?

Can you pls help me with a printing query. I have the option to fit 1 to 1
but I would like to divide it in two like creating a page break but that
option is not available.
thank,jose

How can I make that the printing set up for the first tab applies to the rest
of the tabs in the excel file.
Thanks,
jose

Got a spreadsheet that's consecutively numbered.
Need it to keep consecutively numbering as I add and/or delete rows
Example:
1  Blah-blah-blah

I have the code below that jumps to another cell based on the data entered in
A2, but i need to tweak it so that it allows the data in A2 to be the result
of a formula and still jump to the specified cell based on the A2 results.
Private Sub Worksheet_Change(ByVal Target As Range)

Could you please let me know how do i get the names of about 10-12 excel file
names, which i have in a folder, listed in one excel sheet.
I have about 45 excel sheets in a folder. I want to know if there is any way
i can get the names of these excel sheets listed in one common ...

Excel 2003 SP2+
I had a 2007 workbook that I copied/renamed to 2008 and retained the 2007
workbook.
Now when I open the 2008 workbook I get a message "This workbook contains