using conditional formatting, I want to highlight a recap cell at the top of
the spreadsheet when all cells in the range below are equal.
thanks!!

I have a spreadsheet that list the same ssn several times but with different
numbers in another column.  I need to sort by A and B and input a space after
both a and b match but the whole set not each match.  Then those need to sum

how do i take data from the same ranges in multiple worksheets with multiple
criteria and use it in a sumery

I have a column in which I have custom formated about 50 cells to add
prefixes, a name such as <"Developer -"@ > Developer-Peter instead of just
Peter, Accountant-John instead of John. Now I want to make this custom
formating permanent. I have tried using paste-special and pasted ...

Hi everyone, for some reason I have a few misc. characters that appear at the
start of each comment box I open. In order to make a nice clean neat comment
I have to delete them every time I create a new comment. Any idea how to
permanantly clear the comment box?

is there an easy way to find the same value in different workbooks

I need to count the number of rows that have specifiic data in specific
columns.  There are multiple columns to check for data and all colums must
match a specific value or range of values.
I have a formula below that works and is close to what I need, but I need to

How can I sort in groups of 3 rows? I have client infor in 5 columns and a
sixth column for a state abbr. to sort by. In the column format I used center
across section unstead of merging 3 columns to get excell to sort the entire
row when sorting the States. This worked well, ...

I have 2 spreadsheets, Spreadsheet 1 has a beginning batch number in Col. C,
an ending batch number in Col. E, and a tape number in Col. F.  The other
spreadsheet contains batch numbers in Col. H.  I need to get the tape number
from Spreadsheet #1 that corresponds with the batch ...

I would love to be able to put a wrap text button on my toolbar.   Is this
functionality currently available?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I want to create a summary sheet that will lookup a particular cells value on
multiple sheets (averaging 58 sheets) in a workbook (e.g. $J$19) based upon a
cell next to it ($I$19) that will match the criteria on the summary sheet
(e.g. w1, w2, w3).

I'm trying to convert times every month between my location and up to 50
locations.  Depending on the date and which city/country/daylight savings
time, it is inconsistent.  I've used the world time and date clock website
which is helpful, but was wondering if anyone knew of a ...

I have a database of containers, example as follows:
Column A    Column B     Column C   Column D
Port Load    Port Unload  Cntr Size     Container No
ANT                     MTL             20                AA123456

I assume I use a lookup function, but not sure.  I would define the range
with a name, I know that much, but the formula stumps me.  I have a list that
could read something like this:
JAN    Con-Way    2

I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
serial format).
The second spreadsheet contains two columns. One containing a serial