I'd like to have specific cells change to a certain fill color when I type in certain letters or numbers. Is there a way to set this up? XP Pro Thanks!

IN MS EXCEL 2000 IN WANT TO CONVERT NUMBER IN TEXT FROM ONE CELL TO OTHER CELL WHEN I WRITE CURRENCY IT WILL CONVERT TO READABLE TEXT FORMAT NUMBER E.G 1000 TO...

i need to search for an occurence and when found insert a comment in the next column. i.e. So when EW is found in column A the letters EW will be written into...

How do I write the following formula: I am in cell I6 If g6 AND h6 is blank, then blank, else I5 minus g6 plus h6 -- Richard...

My job needs input info.... plzzzzzzz if you can help...........

I'm working on a job applicant scoring system. I would like for any text that I type to represent a number value that I choose, so that I can...

HELP! I have a multiple sheet workbook each with an identical table that needs to be sorted on a specific column at the end of the month. When I attempt the...

Hello: Running W98 I would like to insert some data rows from one spreadsheet into another. The data in the older spreadsheet has a row format of date, X,...

Is there a way to stop the Comment boxes in Excel from changing in size or position? Some of the comments are squashed flat, others stretch over several rows,...

How do a set the default to move the cursor to the next column instead of down to the next row?

I have a very basic spread sheet which adds VAT to various cost figures. I have a total VAT cell below the VAT columns. When adding the columns together the...

Hello, I have a spreadsheet with 50 tabs. Each tab has a 6 month audit score that looks like this: MAR APR MAY JUN JUL AUG 100% 100% 100% 100% ...

I am trying to get the data i enter into my charity subscription workbook, to be automatically updated in my gift aid register (workbook) so that i do not have...

Can anyone tell me how to finally rid my spreadsheets of that annoying background watermark page number? It shows a big over-powering "Page 1" on the sheet. ...

Is there anything in Excel that will show a history of who accessed, modified, and/or saved an Excel workbook other than what's in the file properties dialog...

Can you give me an example of how to input value to get a specific result for the goal seek function;i.e, what values do we input in the boxes to get...

I have a worksheet which calculates a duration in hours...is there a built-in number formatter that could display that as h:mm:ss? How would I create...

Hi Everyone, I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at...