how do i copy conditional formating from one cell to other(in code)?
another question: how do i copy cell (or cells) without conditional
formating but with all others(formula, formats, values) (in code)

I have a spreadsheet with numerous columns of formulas.  I had to take out
the columns A-V which left about 25 columns with formulas.  I would like to
move the remaining columns to start in column A but do not want to have to go
through all of the formulas and change their ...

How can i assign a macro to change the color of the whole sheet based on a
value?
ex if b1 > 295 change the sheet to red?
Thanks

Using Excel 2007
In cell (I1) on table Input!I1, I have the equation
=DATE(C1,C2+1,0)
On a different sheet, in the same workbook I have the equation

I'm new to excel and working on 2007.  This I know will be an easy one for
someone out there.  I have the figure 36977 and want to add 8% to it via a
forumla.
I've had a look about, but everything seems a tade more complex than what

I copy data from a web page and paste it into a table.  Then in other
tables I do some calculations.
For example I have this formula:
=IF($F$1="","",(0.5*(B4*($F$1+1)*3)-1))

I am workin in Excel, and have an issue with filtering a column
automatically. The column is fed by formulas in the cells. I want to auto
filter the column (non-blanks) and this works fine. However, when the input
data is changed, and the column fills with new values, the filter ...

I have regular order files come in where each product/ customer has one line.
for example, if a customer ordered 3 products then the would have three lines
in the order file, one for each product with repeated address information
across the 3 lines.

I have an excel spreadsheet consisting of 58,000 rows. Every other row is
empty and I would like to delete the empty rows.
Is there an easy way to do this...thanks in advance...j

Im am trying to set a system where you would have to example:
Date          Data Range        Relevent Location
29/10        10 - 20                          1
30/10        21 - 42                          2

can you change the default behavor for the paste command so that it pastes
values?

I using Microsoft Excel 2003 SP2, I have this problem when I opened new
spreadsheet, the horizontal column appear as number e.g 1,2,3 ----
Default should be a alphabet label.
Existing spreadsheet is OK, horizontal column appear as alphabet label and

I recently received an excel file which had a Flash Program in it and
nothing else. The Flash is basically a game where mosquitos come and suck
blood from supposedly your vein and you got to kill them before they really
suck it off all. As many mosquitoes you kill, your score ...

I have a spreadsheet with data as follows:
            A              B              C              D              E  
          F
1     01/07/08   01/14/08   01/21/08   01/28/08   02/04/08   02/11/08

I have a list of 262 different calls. For each I have:
Start Time
Rung Till
Call Lasted Till