I am having trouble with some conditional formatting of times. I set up a
rule so that if a value in D2:M2 is less than or equal to the value in C2, it
will be highlighted (yellow background). The problem is that C2 is based on
an average. For example, C2 says 0:43.2, but it is ...

Up until a few weeks ago, when I dragged a .prn file into excel, each line
would appear in a single cell.
Recently, excel now parses the file into columns, based on spaces in the
.prn file. I don't want this. I prefer each line in a single cell.

I am looking at four columns across of data.  I can do a simple Min to
find the lowest value of the four columns, but in the cell to the left
of the results of the minimum, I would like to identify the column
header for the results.  Is that possible.

I am making a spreadsheet with due dates and completion dates on it. I want
to format the due dates to show up as on-time (green) or late (red) based on
today's date. Once the step is completed (a completed date is entered) I want
the color to stop changing based on today's date ...

Can I still buy Office 2003 Pro so I do not have to bother with the confusing
new menus in Office 20007?

I've got two worksheets in a workbook.  In one of them I am creating a
seating chart for an auditorium.  I have five rows of seats with the rows
running horizontally in the worksheet.  In the other sheet I am trying to
link to the first sheet and put those students into a ...

I have a spreadsheet that is 5 mb and I can't figure out why.  It is WAY to
large for what is in it.  It is a fairly simple spreadsheet to keep track of
my personal & work mileage.  I created it as I have many others - but this
one seems to have some issue that is making it so ...

What would be a command line to change the results in a cell from #DIV/0 to
zero?

I have problem with some of the macros in modules missing in
personal.xls . I have multiple macros in multiple modules in my
personal.xls. When I try to make a copy of the personal.xls on the
same machine, the new copy of the personal.xls has some modules

I am trying to create an if then formula for the following but am having some
difficulty. Any assistance would be appreciated.
If  C2 is greater than 2 but less than 6 than it equals C2.
Mike

I have a pivot table that I constantly update the data for but when this is
refreshed on the cells that should show "Known As" I am seeing a number "1"
instead .
I have tried various ways around this by changing the data page to rename

how can i feed time in military format? e.g. 1210 for 12:10 PM, 1740 for
17:40 PM, 0030 for 12:30 AM.

do you have an idea why did it happen?
do you have an idea how to solve it?

I am getting an error when i try to save my workbook "File did not SAVE" i
have tried doing a save as and just a save nothing seems to work. Any help
would greatly be appreciated.

I have imported a database and cannot format the phone numbers I have tried
formatting the cells prior to importing and also tried conditional
formatting.  For some reason these numbers always show up without a space
between the brackets.  Can anyone help?