but, i'm an idiot.... column "P" is sum of Columns "C-M" (and formatted for % if that makes any difference). i want column "P" text to turn red is value is...

I have 2 spreadsheets that both contain store numbers and the accounts they belong to. I want to compare the two files to make sure that all of the store...

Our company uses a report writer/formatter that creates Excel spreadsheets and then sends them as email attachments to specified users. The data being...

ItemA ItemB ItemC date1 34% 0% 91% date2 0% 0% 12% date3 100% 80% 90% These are...

Excel 2000, Vista How do you refer to the info on the tab (worksheet name) in a cell in the worksheet Thank you, Bill

Hi all. This one is driving me insane. I have a spreadsheet (MS Excel 2003) with a range of dates in column A. While I was working on another area of the...

How am I to set different password for different worksheet ? This to allow certain person to see only certain worksheet when clicking on one password...

gjgnu ffg sd khdgub adfycbhjvsd

I want to create a button that you click, it asks you to enter a number and then it is highlighted. I have never used macros before, how do you...

Just have a look at this EURO 2008 spreadsheet. Its quite light and useful. It also have an online version. Excel users follow this...

I have typed Accession numbers of my library books in the coulumnA randomly and sorted them in ascending order. Now i need to find those Accession numbers...

My question is revolved around using shared workbooks being updated by different users. It seems that each person is having to setup the formats, page...

Hi, At the left bottom corner of Exel 2003 spreadsheet, a display note 'Ready' remains as it is, though I have filtered the items using the filter command,...

I have tried two different formulas to Average / Median a column of % here are the two...

I would like to be able to create a FORM on say sheet one. I would like to have about ten fields on the form I would like to then have a SUBMIT button which...

Using Excel 2002 This is what I want to do... A1 = a number or text A2 = a number A3 = A1*A2 If A1 is text, what is the correct IF statement in A3 so I...

I have a Loitech Mouse with a scroll wheel that will lean to the left and right controlling the horizontal scroll bar. This works very well in most packages...

I am attempting to setup two columns. One column is adding charges. The other is showing the charges deducted from a starting balance. I am trying to keep...

I am unable to copy and paste a formula from one cell to another. This is rather weird and something I have not encountered before. I will appreciate some...

I have an Excel 2003 spreadsheet with 8 columns, A-H. I have "frozen" the first two columns, A & B, so that I may scroll back and forth between columns C-H,...