hi guys, just wondered if anyone knew which function i would use to do this,
because im fairly novice with excel:
Basically if the cell value is above 110 i want the cell to turn green
            if the cell value is between 110 and 105 i want it to turn yellow

I create if else statements often.  But I find it tedious to have to
type them and redefine them all the time for different workbooks.
For example, let's say you want this type of if else condition for
calculating price to earnings:

I use "Control [" to go to the first component which makes up a
formula.  Suppose, for instance, that the formula consists of the
following:
=a35*(1+b37)*'Sheet 1'!c27

Before deleting any worksheet tab, I want to find out if there's
anything that affects other worksheets.  Any way to check for this
short of clicking every cell and using "Trace Dependents"?  
I know the spreadsheet gives message that deletion may affect other

I know excel has the feature I simply don't remember what it is
called.
Lets day I have three fields A, B, C.
A and B have a value of some number between 1-10.

I want to use add-ins in excel 2007 - e.g. Anaylsis toolpak, and others for
biostatistics. They are all loaded, as I have verified this in the Excel
options / Manage Addins dialog. However I can't see them anywhere. In Excel
2003 the buttons appeared on the toolbars, or in the ...

How do I loop through a range of cells (A1:Y40) looking for a match to
another cell (Z1).  There will be multiple matches.
When a match is found, I want to subtract the 2 cells prior to the found
cell from each other and accumulate all of the results.

Can an Excel spreadsheet be distributed that allows only limited values be
changed, not formulas, to users without Excel?
Sort of mortgage amortization tables, etc. as example.
User can plug in some numbers, see results, but can not change the core

There is a DDE compatible stream of data. I want this data be inserted (row
insertion) at the top of the worksheet each time the imported data is
different from that stored in the worksheet. The beneath rows should be
shifted 1 row down, thus making some sort of shift register ...

I'd like to be able to do an intelligent lookup of a suburb and then have
the postcode automatically show in another cell. I can do the vlookup of the
postcode once i have the suburb but I'd prefer not to have to use a dropdown
box for the suburb (there are THOUSANDS!)

Using Excel 2003...
Monthly, we send excel spread sheets to clients who edit them and then send
them back.  Unfortunately, buy the time they send them back, they have
usually renamed them.  We are always worried that that are sending back an

I want to divide one number by another and round the answer up to the
nearest hundreth.
   Ie, 38 inches divided by 12 equals 3.17.
Right now I can DISPLAY the 3.17 but when using that in a formula it's

I know how to check a column for a duplicate entry.  Is there a way to
check and highlight duplicates within 2 cells.  Here is an example:
Sales order       Line #
1234                     1

How would I change the format of a standard time like 1:31 (1 minute
31 seconds) to a DV timecode format of 00:01:31:00 easily?
Thanks

I could use some help with an Excel Waiting List I am trying to create. My
first column A is labeled Date and I formatted it as date. I have typed in
6/1/07 in A-1; I would like it when I type in in A-2 “6” the 1/07 is filled
in already for me. The reason, this is a log of calls ...