I would like a cell to turn red if I enter L or PB. Normally I would use a 2 conditional formats 1 for L and 1 for PB, but I need more than 3 conditional...

Hi, Can anyone suggest a way to achieve this: I have received a spreadsheet with almost 5000 rows containing information on items, one item per row. The rows...

Hi Everyone! I'm using a MIN function to find the lowest value in a set of 10 values that I am downloading from the internet. The problem is, the data...

Hi I currently have some data as shown below: Item 1 0 Item 2 3 Item 3 6 Item 4 5 Item 5 0 Item 6 9

How can I compare a master part numbers list in one Excel column or worksheet against actual values in a second Excel column or worksheet, and display...

How do I repair an Excel document I accidentally opened in Word? I want this to be an Excel documet again. Thanks!

What are cell relationships and how do i use them.

I have a workbook that has 32 sheets in it. I would like to export each sheet into its own htm file. Is there a way to do this automatically so I don't have to...

How come Excel 2003 mis-translates all imported dates withint the 1st to 12th of each month, even though I have correctly set my Regional Settings ? I'm...

I having a problem with the web part creator. It appears to be unable to save to the document library. I receive error 501 - not implemented. I can save Excel...

How do you switch between desing and run mode of a button that runs a macro?

I imported a list with 4300 members into excel and right now it is 103 pages to print out. Is there a way to set the spreadsheet up to have 3 columns without...

I am forced to use "Open With" to open Excel files, because they always save as notepad files. I use Windows ME.

For a change the March stats are available rather quickly. :) http://www.tushar-mehta.com/excel/ngstats/index.html -- Regards, Tushar...

Can't find 'top' as an option when I go to cell alignment in Excel 2003. Some websites show 'top' as an option for cell alignment, but that must have been with...

I am trying to copy and paste named cells from one workbook to another without having the first workbook file name attach to the named cells. For example, I am...

Hi, I would like to copy, paste data from one sheet to another sheet. I have made command button with this code, and it doesn't work. If someone can...

Hi I have a problem with external data. In the Data Range Properties, under Data Layout. There are 3 options after 'If the number of rows in the data range...

have a workbook with 500 spreadsheets. Have one template and using CTRL-SHIFT to copy template to new spreadsheets. Worked good till yesterday. Now...