I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each cell.
I looked at the referencing and all is correct. I looked at the tools options
for the cell referencing and tried that option but ...

I created a form utilizing the data validation and the Indirect function. I
have a list of products in Column A, depending on the product selected,
certain options are available in Column B.  I want to create a warning
message if one of the options in Column B needs other ...

I have 7 rows in the same column of type percentage.  I'd like to turn
the text of the highest valued cell red.  How exactly is that done with
contional formatting (vs. IF statements for each cell)?
Thanks,

is it possible to assign/enter several individual separate comments to a cell

I read previous posts about not being able to trigger a macro through a
function.  So my question is: Is there any way to have the macro see
that the IF function is at "true", or false"?
What i am doing is i have an nested if function that says wheather a

When I have the worksheet filled with different colors to distinguish certain
things it will not sort alphabetically. Can anyone help?

Good Day,
I have two columns of data With the following in each,
in Cell L2 and filled down is
=IF(H2=10,IF(U2=1,"$",1),IF(L3=1,IF(U2=1,"$",IF(W2=1,"Trl",1)),0))

I need the below formula to also sum "Closed / No", since column B contains
both entries.  Not sure how/where to add it to this formula.    
=SUMPRODUCT(--(Overall!B8:B1026="Closed /
Yes"),--(ISNUMBER(SEARCH(G11,Overall!D8:D1026))))

Does anyone know how to average a range of numbers based on a criteria
where the numbers have to fall within a range of data? I have trie
combining a number of statements and nothing is working. I want t
average a column of numbers that will have data added to it every day

I have three coloums of data which I want to put into a table format (below)
COL A as the rows, COL B as the column headers and COL C as the data
I have tried using a pivot table but the Data needs to be numeric, therefore
doesn't work. The same with sumproduct

I have a spreadsheet that has (among many other things) three columns of data
for one farm. (see abbreviated example below)  One is a field identifier, the
next the practice occuring on that field, and the next the size of the field.
At the end of the ACRES column, there is a ...

I have 55 worksheets in a file, they are all formatted the same way. Each
sheet has totals entered for individuals by catagory and by date.  I would
like to create a new worksheet that I can display totals and averages from
the data on the other 55 sheets.  Is there a way I can ...

I work in large Excel data files where I frequently do a "countif" to compare
account numbers.  Sometimes, the "countif" function will result in displaying
the actual formula in the cell, rather than the result.  I have tried to make
sure the cells are formatted correctly, etc., ...

what will be the VB code to protect sheet. thnaks

Is there a function or VBA macro that will return the width of a column?