I need a formula to say if cell A5 = Brochure OR Datasheet OR SolutionBrief,
than place an A in the cell, if A5 = Whitepaper or ExecutiveBrief, than place
a B in the cell, if A5 = CESuper, than place a C in the cell or if cell A5 =
CaseStudy, than place a D in the cell.

I am using Excel 2007 and I am having a problem changing cells with my arrow
buttons on my keyboard.
All I am trying to do is go from one cell to another using my arrow buttons
on my keyboard. Now when I hit the up (or any other) arrow my entire screen

Hi,
I'm looking for a way to change the color of one cell when a specific value
in another is entered.
For example, if A1 is equal to "Collateral", I would like D1 to become RED.  

Hi,
I'm looking for a way to make a "pop-up" appear when a particular cell is
left blank.
For example,

I have a workbook that was locked and I do not have the password. Does
anyone have an idea how I can display a note to anyone opening the workbook?
I tried using a macro, but since the wb is locked it will not work.
Thanks

How do I get =NOW{} in a cell that show a date that changes whenever I open
a sheet?  It worked before. What am I now missing?  I seem to get a number
in the cell.

a1:a50 is a list of item keys.  b1:b23 is a list of counties.  I want to
create a two column list (it would have 1150 rows:  50 x 23).  It would have
every county for each item key.

I am summing cells that are based on the results of a formula and the result
is displayed to 2 decimal places. However the total sum doesn't match the sum
of the numbers displayed in the cells.
How do I get the sum to equal the displayed amounts in the cell versus the

If somebody knows, please help me.
I really appreciate your help.
The previous programmer created an excel template file(.xlt) in lower version.
If we save this template file as [CSV (Comma delimited)(*.csv)] format in

I used the series option to autofill a column with numbers using Excel 2003.  
However, I am not able to duplicate this process using Excel 2007.  One of
the problems is that the "Series" option is grayed out when I select the Fill
Menu.  If I could ever select it, I am sure I ...

I had a number of columns that contained formulas and i used the "Paste
Values" fuction to replace the formula. The problem is that the values are
not being treated like numbers. If I look at the values in the cells the
numbers appear with with the justification characters beside ...

I'm trying to figure out how to add a columns of numbers if there is a number
in an adjacent column.  So for example if cell Y245 and Z245 both contain
numbers then Y245 would be added to the sum but if if Z245 did not contain a
number then Y245 would not be counted.

There are about 500 managers, when I choose a manager's name from a drop down
(in a form) I want excel to insert the manager's file number in an adjacent
cell.
i.e. Joe Button - 1875

Can you set up just one sheet in a workbook to recalc manually?

I have a button at the top of a worksheet but when I scroll down the button
stays at the top.
What I would like it to do is scroll with me so the button is always visible
for what I'm looking at below.