formato condicional en celda valor nulo

I recently reinstalled Windows XP PRO SP2 and Office XP Small Business
Edition SP3. After that I noticed that double clicking on a XLT file just
opens Excel, but doesn't create an XLS file based on the template. This is
only happening on the user's account, there's no problem on ...

If There away can simplify a Sumif Function?
I have the following formula
=SUMIF('CS1'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS2'!I10:I119,"=1",'CS1'!F10:F119)

Please excuse the crosspost, but I'm using Internet Explorer to post this and
cannot figure out how to multi-post.
I have a need to collect some information from a wide variety of sources
throughout my internationally dispersed organization.  I cannot use an

I have a worksheet in FileA and I want to copy it to the range from R1 to X10
of FileB by using VBA.  Could someone please show me the procedures.  By the
way, shall I activate / open FileB before copying.
Many Thanks

I have a workbook that I add nearly identical worksheets to each week.  Is
there a way to, for only this workbook, change the page setup defaults, so
that the margins, headers, footers etc are set the same as the rest of the
tabs in the workbook, when I instert a new sheet?

I have a workbook with 2 identical worksheets. When data in one row in the
1st worksheet is no longer needed, I cut the whole row and paste it in the
second worksheet. I noticed that when i do so, the formulas change. For
example, i have a formula in the 1st worksheet to ...

When I click on either the bold, italic and underline icons on the excel
toolbar, the program freezes and stops.

I really hope i can explain myself. Sorry if i can´t.
In 1 column (A) i have the total of hours a tractor has worked. The results
are daily and may vary. How can i insert a "OIL CHANGE" (column B) saying
that a oil change is always needed after 250 hours?

Does this version have the capability to covert numbers and letters into a
scannable barcode?  thanks.

I have several spreadsheets in my workbook which have a column with the same
reference numbers.
It is frustating to filter each spreadsheet individually...
Is there a way to filter for a reference number (in all the spreadsheets

I've added password protection on a worksheet in a workbook and am now unable
to get to another worksheet in the workbook.  How can I access the other
worksheet?

Data is as follow:
     Name        ID            Birthday
c1  James       123456     01/01/1900
c2

Am using Excel 2003... in my cell A1, i typed the following using Alt
+Enter
Orange
Apple

I have many spreadsheets each for one company of a group.
Currently I filter each spreadsheet at a time when I want to see the
relevant area.
Is there a way to filter each company's spreadsheet with only one action on