I need help with creating a formula for the following:
If cell F is 1.25% more than cell E than turn cell I black.
Please help

How to set a formula in Excel to find the numbers of series :
1000, ....., 500,000 (total 20 numbers) and the sum of 20 numbers is equal
to 1,000,000.

how to write ①

I am using Excel 2004 on a Mac and I am trying to import some fianacial data
from yahoo fianace but it seem like I am allow to import data from MSN money
central.
Is there anyone who can help me on this?

I am trying to work out a value.
  A1             A2           A3           A4            A5
£0.49    10.00%    2.50%    13.50%    ?
A5 needs to calculate A1 - A2 -A3 -A4

I've come accross a problem in Excel 2007 on a worksheet with some clipart
images and text. I can open it fine but if I click on the print preview in
the quick access toolbar, it will preview fine but when I close print preview
it distorts the document, text and images move all ...

Is there a way i can turn every instance 0 to the text zero using the custom
formats option under format cells?  Also is there a way to change the colour
of every piece of text in cells.

We have a number of staff still using Excel 97.  When they download a file
from a website, the data for some users appears in one column and they are
required to use the text to column function to separate the data.  However,
for other users it will automatically separate the ...

using excel 2003. I have multiple sheets. I want to set the page margins - is
there a way that I can set the page margins for the entire workbook, so that
while printing I don't have to set the margin for each sheet individually?
thanks1

can someone please help.  i have the following code for saving the same
template with cosecutive document numbers on our network.  a drive "Z" was
created where every document is saved, but what happens is that 4 computers
are used for quoting by different people and it seems as ...

Guys,
I am looking for a way to decide whether an excel file has got some VBA code
in it?
How can i achieve this without opening the excel file and macros. I have a

I'm taking a shot in the dark here but can MS Acess be linked to an Excel
worksheet?  At work we use Acess(gatelog) to track people in and out.  We
then transfer those times for people manually to an Excel worksheet.  Is
there any (hopefully easy) way to link the two so the Excel ...

hi
I am using Office 2007. I have created a pivot table using an excel
worksheet e.g. the pivot table range is A1-Y1000.
Recently i have added a new column but the pivot table is still reading

I have one spreadsheet that will not let me insert a cell or row and gives me
the error 'cannot shift objects off sheet'.  There are no objects and/or
comments on this sheet, so please don't refer me to the knowledge base
article - already tried that.  No hidden columns, cells, ...

I am unable to insert rows in an existing spreadheet and a new one I just
initiated in a book with multiple sheets.  What did I do to cause this and
how do I make it go away?