I've seen it in other sheets but can't figure out how to create one.  I'm
trying to create a dropdown list that changes color whit each selection.  For
instance, Pass = Green, Fail =  Red and Not Executed = Yellow.  I'm able the
create the dropdown list and put it in the cell but ...

I have a Microsoft Excel Users Manuel that says the following on calculating
part of a formula. (This is apparently Version 4 so the info is out of date.)
1.    Select the cell containing the formula or type the formula in the formula
bar.

I'm not sure if this is possible with excel functions (and I'm only a
beginner at VBA).
NOTE: I did post this question earlier but I did not word it clearly plus I
am including an example.  

Just found out about this group and can see that there is a wealth of
experts and information here.  Hopefully you can spare some time to
help this fellow out.  Here is the situation:
I have a workbook with worksheets for every employee on a certain

What formula can i use to get the total of cells by counting text with
diferent color?
ex:
NAMES

Hello, I've been trying to create a sheet with a kind of recursive arguement
the idea is that cell b15 uses the value from b14 uses the value from b13
uses the value from b12... up through b2.  While I could enter each one by
hand, is there a way to dynamically define the ...

I'm trying to find a way to look up a single value in one column which has
multiple results in the next column.

I have many names and addresses in a word file presented in list such as;
Mr John Banana
207 S. Fruit St
Health City, IL 18724

Is there a smart way to sum numbers not knowing the last sheet i should
consider in the sum?
Thanks, Stefano

Hello.  I have 5 sheets (named Sheet1 though Sheet5).  On an input
sheet, I wrote sheet1 though sheet5 in cells A2:A6, with a 1 or 0 in
column B.  Is there a way sum cell A1 in each of the sheets that have
a 1 next to it in column B?

Okay I've got dates in column A, column L has the number of days since the
column A date, and column N has text that says either "maint*" or "ent*."  
I'm using the following formula to calculate the average number of days in
column L for specific dates in column A:

I have a multiple Worksheet Excel File with a curious problem on one
Worksheet Only where the In-Cell Dropdown has suddenly stopped being
Displayed for All the Cells that have Data Validation enabled.
I have tried to reassign the Data Validation Format again and again, I have

Is there a way to break out of a Find and Replace procedure that is looking
for a link that it cannot find.  I had an instance where I did find all and
noted that there were 388 cells that included what I asked to be replaced.  
Then I made the mistake of clicking Replace All and ...

I have a workbook with several pages of data.  I have a sheet named Reports
that has several charts that display the data from other sheets.  This week
the entire page of charts cannot be editted, the drawing toolbar icons are
dithered out and cannot be used, the protection ...

Solograndma back with another complicated formula problem.
In my workbook I have a data entry sheet that transfers data to a printable
sheet. I have a copy and paste function with mid-range formulas for and
address as well as a manual entry area. I have the formula to use the ...