Is there a way to format 2 rows, skip to rows, format 2, skip 2 ... using
conditional formatting?  I'm familiar with =MOD(ROW(),2)=0...but it does
every other row.   I want it to skip two rows, format the next two, skip 2,
format the next two, etc.

I'm trying to set up a worksheet that uses drop down boxes and I have
the validation set up and everything with that regard working... the
problem is... I can't find a place to put the data?
The data will be in Colums A-I - but the number of rows will continue

I'm creating a huge directory and I'd like to include internal
hyperlinks. Is there a FAST way to do this? i.e. I need to create 2000
hyperlinks, leading from one cell to a cell on another worksheet.
Tips?

How can I lock and unlock multiple tabs at once.  This workbook contains 100
tabs.  I will be nice to lock and unlock all the tabs at once without having
to go thru the tabs individually

One of our users sent me an Excel file of 6 MiB.
It has 7 worksheets. Most of them have <100 rows and AH columns, one
sheet has 13160 rows and AH columns.
The large sheet has autofilter enabled, but no actual filtering is

Is there a way to have an Excel (2003) cell display a percentage
result from a calculation as a shaded percentage of a cell instead of
returning a result? It seems like that sort of thing should be in
Format Cells... > Shading, but there's nothing there. This is possible

I'm using Excel 2000.  have created a document, uploaded it to google docs
and spreadsheets, exported it as a doc, converted it to a spreadsheet (excel)
and uploaded it again to google docs.  It's not a complicated file - no
calculations or anything, just a simple log to enable ...

Hi All,
I would appreciate greatly if any vba expert could help me with this
solutioning urgently as my deadline is drawing near (today) and i could not
resolve this solution for cell comparison.

Does anyone know if i can insert our company logo into the header in excel
2000?
Kirstie

please answer

To run a macro everytime I open an Excel document, I made a macro in a file
named Personal.xls in ...\Program Files\Microsoft Office\Office10\XLStart.
The macro runs well, but when I save the document it makes two files, one
with the correct name (that I want) and another with a ...

I'm new to this forum and have a question about repeating things in cells.
How can I paste the contents of one cell into more than one cell?
I'm trying to make an address book and take the state abbreviation into
several cells.

Can someone help me write the syntax that will correctly count the data in
ranges for compass points...
Something like this:
=countif(v4:v800, ">22.5") +? or -? countif(v4:v800, "<67.5")   etc