What code may be applied with respect to only ONE sheet, upon which if any
data is pasted (either by Ctrl+V or Enter) only the values are pasted so as
to preserve the format and application of Conditional Formatting?

I have 2 xls, I have named them big and small.  
They contain the same information but the size is very different
for example the big file is 2,128K
the small file is only 40K

I developed an application in excel 2003. The application incorporated use of
toolbuttons with associated macros.
When opening the application we discovered that the buttons referred to a
map on the memory stick, we used to transport the applicaton on. In the 2003

I am counting the cell which background color is red. and each cell i m
useing conditional formate if value less than target it means cell background
color is red other wise its normal. my purpose is count how many task is
pending. so i can use function colorcount() as:

I'm having trouble deleting rows in Excel 2007 using filters.  I have a large
volume of data from another program which I import in Excel and a simple
macro went through and deleted all the garbage lines.  I encountered a
problem moving from Excel 2003 to 2007 as when ...

I am trying to find a formula that allows me to know how many days an
employee took as a vactaion on each month a summary sheet for each
employee
In order to find the number of days taken i have use the following :

I would like link cells with macro in Excel (if this is good
descriptions):
In cell A1, I have list od three options. Dependensy I choose some
option from the list, than in B1 I must have correct list.

In Excel 2007, I get an error when trying to use table names in formulas. Eg.
I am trying to 'Sum' a column of figures whose heading is 'Jan' and I have
entered the function as =SUM(Jan). The option 'Use table names in formulas'
has been activated.

So I need to build a matrix, and I suspect "SUMPRODUCT" will be friend on
this, but boy, is it scary.
I have a list of SKUs, the customer(s) who bought each, and the quantity
each customer bought:

hi
i need some help if possible.  i have a spreadsheet that i have designed for
invoicing.  i have a drop down list which i have used data validation for
inputting materials and need the cell next to this to automatically put the

 I have scanned in a hand-written signature to add to Word documents.  I am
trying to add it to Excel, but would like to be able to put it behind the
rest of the text in the spreadsheet, so the white spaces around my looping
letters can be overlaid with the spreadsheet text.  As ...

I am trying to add a conditional formula to calculate commission sales and I
keep coming up with #NAME?.  The criteria I am working with are: if the
amount in cells  B3 thru B8 are less than $1000 then the commission is paid
at 5%, if it is between $1000 and $3999.99 then the ...

How do i increase the number of columns in a worksheet? there only seems to
be 150 - 200 or so and i could do with around 400. I've tried "insert" -
"column" but the amount of columns available doesnt increase!

My cell references in excel are displayed as RC[-2]. How do I change to more
convential R3C2.  I am using Office 2007.

I am using delimited text-to-columns in Excel 2003.  I would like to
break up a single text column into two additional text columns based
on the 1st two occurances of the space delimiter (" ") within each
cell.  All other spaces should be ignored.  Finally, for what remains