I have a workbook with multiple spreadsheets. I need my cells to have
conditional formatting. I have set up:
If less than 0: Font should be Red
If equal to 0: Font should be Black

I have a spreatsheet in Excel 2003.  It is used to track Purchase Orders.
Column F is the Date the items are needed to arrive.  I would like a
conditional Format that would change the cell with the arrival date to Red if
the Item is within 2 workdays of the date that is in the ...

How do I clear a cell instead of blanking it.
Here is my current formula:
=IF(E5="","",SUM(B4:B5)/SUM(D4:D5))
I am using this for a chart and I don't want to blank the cell becauase it

An information system I work with outputs times as follows to a csv
file.
748 for 7:48
1236 for 12:36

I have a large number of cells with date and time like this, "Jan 12,
2001 5:55 pm"
I want to truncate the time in the cell and only make it display the
date.

I had posted this same question. I did not get a good answer. But now I
have simplified my own question. Hope this will help. I need a formula
that deletes entire row based on a criteria. For example
row 1 - contains what i need, so keep it

I want to search sheet 2 for both column a and d in sheet 1, and return
column c of sheet 2
sheet 1
a                b              c                      d

Looking to sumif A1 and B1 = "MOTOROLA   JXP1" then C1 would be the anwser
   A                          B              C
1  MOTOROLA   JXP    1    4
2  MOTOROLA   JXP    2    5

I am trying do do a sumif using 2 conditions
For example:
I want to add the values in column d if the value in column a is either C or
X.

I'm having problems with this and I thought it would be simple.
Basicly, I want to add a value to cell A1 when the spreadsheet opens,
then when its opened next add the same value to A2 and so on.
I thought it would be done with a simple if statement.

Can anyone help me with a script which can remove dashes between 2
letters and between a letter and a digit. But at the same time keeps
the dash beween two digits.
Example:

I'm needing to compare two lists of stores each week, and am wondering if
this can be done using some kind of array formula, or if vba would be needed.
From one week to the next, the list of stores will not change much, but
there could be a few stores that drop off, and a few ...

Please help!

why would the copy/paste function stop working on a spreadsheet

Does anyone have a code that will open a workbook w/name Table.xls that is in
the same directory as the workbook w/name 248.xls that is open.   I would
like for the Table workbook to open when a user opens 248 workbook.