Hello, I have a column with 1000+ rows, each row having a 0 or 1. I'm
looking for a formula that will give me the highest number of consecutive
1's in the entire column. Just in case I didn't explain this correctly, here
is an example with a column fragment laid sideways:

If A1 is numbered 1 thru 4, representing Black, blue, green and red, is there
a way to change the font color for an entire row based on this?  i.e. if I
place a 2 in cell A1, I would like the entire row of numbers and statements
to change to a blue font.

Hi,I am Cho
I have about 1800 microsoft excel cell that contain the various result of
formula.Now I want to delete the formula but don't wanna delete the
result.Is it possible.

Goood Morning fellows :)
I several matters you have given me your kindly help - and I still hope
to get on track on this new issue by your qualified respons:
I want to use my (rather large) woorkbook for another issue - and have

I have created a soccer form for my church soccer team that I would
like to share with anyone who might need it.
It has 4 sheets. They are: Player Information, Lineup, Handouts and
Schedule. Everything is pretty much automated after you enter the

I'm using regular Excel formula in the cells (not scripting, mainly
because I don't know how). I have a problem with trying to combine
offset() and small()
my actual code is:

Excel 2003 SP2
Trying for format a cell based on the sum of a range in which the cell
exists versus amount in another cell.  So if the number in the cell changes,
making the total of the cells exceeds a predetermined number, then the cell

I tried to convert the date to YEAR and then the year plus 25 Years
later.
=Year(A1)    I'm getting the result  1900 instead of 1965.
I tried to add 25 years later to 1990 from 1965.

hi, how can i create labels so I can input about 100 names and they will
print off in a label style, Ive tried everything please help!!

If I have a shipping spreadsheet that has a shipping
cost shown by weight on the left and zone on the top , how can i select all
fields and add a certain dollar amount to every field ???
For example

I have absolutely no idea where to start!!!! I know it's simple but
I've never done this before...I needed to figure out how to compare
values in a row and retrieve a value if the condition is true. However
if more than one values meets that condition, I need it to remain

I have the formula in which if I update a cell in a row, column A will
time stamp the change.
Private Sub Worksheet_Change(ByVal Target As Range)
Range("A" & Target.Row) = Now()

I'm trying to set up a workbook where by I have a list of items pending. once
completed i would enter either yes or no.
i want to set up a Macro to move these items/or colour code them.
is there any way to set up a data validation/macro to do this???

How can I view two Excel documents that are currently open on two monitors.
Everytime I open a document each one seems to be contained weirdly in the
same window. I know I can start a new "instance" of Excel from the Start
Menu (this trick doesn't work with PowerPoint!)... but ...

Excel 2003 SP2
Trying for format a cell based on the sum of a range in which the cell
exists versus amount in another cell.  So if the number in the cell changes,
making the total of the cells exceeds a predetermined number, then the cell