I have a spreadsheet that we will be sending out to many users.  It will have
several columns protected and one unprotected so that the users can enter a
Yes or no to that column.  I want to know if I can have that cell protected
once the entry is made or do I need to go back and ...

I wish to change the Font & Background colour if a cell = a certain
value.
I can't use Conditional Formatting as I have 28 variables that the cell
value could be. I have seen an add-in on this Newgroup, but I'm trying

How I add the option to change the color of my spreadsheet tab's (excel)?

Hoping someone can help me with a VLOOKUP problem. I have two simple VLOOKUPS
in my workbook. One works great, the other does not. They are virtually the
same. They both have the same set of numbers but one is reversed from the
other. Example one table looks at 123 and returns 1

I am creating a sales tracker to calculate weekly, monthly and yearly
sales.  There are 5 Week Tabs, one Month To Date tab, and then a Year
to date tab which has a calendar design which i want to only hold the
final monthly data.

In Excel the ISMPT formula does not return the same results as an
amortization schedule. What is the differnce? The interest calculation for
the first payment on the example giving under Excel help is not the same as
the interest shown in an amortization schedule

I am looking for the value when Loan amount is $670,000 with 640 FICO
and LTV 76 and that should give me 3.000
        LTV    0    70.01    75.01    80.01    85.01    90.01
Loan Size    FICO                           

Im hoping someone can assist me in creating a formula that does the following.
I would like to look at cell A1 and if that cell contains a number greater
than 120, to return a figure of 10 for each increment of 30 over 120 but if
A1 contains a figure less than 120 it should return ...

Howdy!
I am working on a project where I have a start time in [h]:mm:ss and
duration of time in seconds.
I would like to add the seconds to the time and come up with a time

I have a spreadsheet where certain cells will not accept my name, but will
allow almost anything else.  I have other cells that have silmilar problems
with other data.  These cells did have validations in place which were
removed.  But I did a Clear ALL on the cells in question ...

I have a series of named ranges that are Question_1, Question_2, Question_3,
etc.   I'd like to reference them with something like this:
"Question_"&A1 where A1 is 1, 2, 3, etc.
within a complicated array formula.   How would I do this so that it finds

I have 3 different worksheets, "01-01-2004", "01-11-2005", "01-01-2006".
In a separate spreadsheet I want to insert a formula that gives me data from
the worksheet I specify.
e.g. In cell A1 I insert the date of the worksheet I want to use, e.g

I am putting together a very simple worksheet for some sales tracking
and I have hit a bit of a road block when I am trying to utilise the
Lookup and Index functions.
I want to be able to pick the type of sale in 1 Coolum from a drop down

How can I choose last filled row and copy it to other worksheet?
People are filling excel sheet and the latest data should be copied to
summary sheet (all can be in same workbook).

I am trying to sort my excel workbook by entry dates. I enter date daily and
my boss wants a report on a weekly basis of only the new items I have
entered. How can I get the program to perform this for me?