I would like excel to ignore email addresses, and stop launching my email
program when I click on a cell containing an email address. I would like to
apply this setting to everything I do in excel if possible, rather than
applying it to each worksheet or cell.

I would like to set up a conditional format whereby if today's date
minus [date in referenced cell] was greater than a certain number, then
the fill colour of the cell would be changed.
I've tried experimenting with setting this up, but just don't seem to be

I have 8 dates in a Range A2:A9 (A1 is header) like so,,  (4 are unique)
MyDates
12/31/2006
1/25/2007

I want to highlight the cells that do not get a result from the VLOOKUP
function.  I tried setting the conditional format to Cell Value = "N/A" (and
other variations) but with no luck.

I'm new to these parts and I'm hoping someone can help me. I have a
simple email list of 4000 addresses (List A) and some are no good.
I've made a separate list (List B) of those bad email addresses and
want to delete all of them from the initial list (List A). Is there a

I want to number my rows. My table is names, addresses, tel numbers, etc. I
would not want the number to be tied to the row because I will be adding new
rows from time to time and the number field would have to adjust accordingly.
Is this possible in excel 2007. Thanks much.

Using XL 07, want to calculate median.
have worksheet of census data by zipcode that makes displays data within 25
miles of inputted zipcode.  these may range from 20 to nearly 60  zipcodes.  
one field is median hshld income.

I need to sort a column say "c" which contains numerical data. When i press
"a to z sort" button the numerical data is sorted as alphabetical data i.e
it  ignores positive and negative signs and after 10, the value 100 comes
and 20 then -20 then 200 like this. How to sort this data ...

I am using multiple Vlookups in one sheet. There is a vlookup in each column
which retrieves data from multiple file locations. So for example, column B
looks at column A, and then goes to File 1 to look for matching data. Column
C then looks at column A, and then goes to File 7 ...

I have a front sheet that uses Vlookup to populate it, for example
=IF(ISERROR(VLOOKUP($E11;Vlookup!$A$5:$ER$59999;4+($B$17-1)*9+I
$7;FALSE));"";VLOOKUP($E11;Vlookup!$A$5:$ER$59999;4+($B$17-1)*9+I
$7;FALSE))

I have a column of free text cells that describe an action that was taken.  I
would like to identify any cells that contain the word "shipped".  (Shipped
will never be the only word in the cell, it is always part of a string of
text.)

Recently some of my spreadsheets do not automatically calculate but require
me to hit f9 or click on the word calculate in the bottom left hand quarter.  
HOw can I set it back to automaically recalculate?
THanks,

Is there a way to add color to the border of the found cell locator box after
a search has been done in Excel.  With my eyesight isn't what it used to be
and sometimes I do not quickly see what my search has found.  If I can add a
bright color the the edge of the box that ...

I have a column of numbers, and would like to find the "largest number".
However I need it to be less than 130. something like =LARGE(C1:C20,(1<130)),
I've tried several different things, but nothing really works.
Thanks in advance!

The cell A has a catalog number in it with the order it belongs in the mix.  
What I need to do is seperate the catalog number from the order number is
there a function or macro that will do this?  Thanks in advance for the help.
   A                       B                 C