| Thread | Last Post | Replies |
|
| Conditional Formatting | 27 Feb 2008 17:49 GMT | 2 |
I have 3 data columns, one returns the solution and need to be formatted to be red or green depending upon the result, however, if col 1 is blank I would like the solution column to be unformatted or formatted white, eg col 1 = 10, col 2 = 12, col 3 = 2. Col 3 would be green, if ...
|
| How to I prevent a row from breaking across pages? ... | 27 Feb 2008 17:45 GMT | 2 |
Is this possible in excel? Please advise.
|
| Dollar range to Percentage | 27 Feb 2008 17:45 GMT | 1 |
Have column with multiple rows with differnet dollar amounts. What I would like to do is write a formula outlining a percentage for a dollar range: $0 - $25,000 = 4% Column A Column B
|
| How can I combine 2 columns of data into 1 and format it as follow | 27 Feb 2008 17:32 GMT | 1 |
I have column A Part numbers and column B corresponding price for the part number in A. I need to create a new column that would be formatted as follows: A1
|
| How to hide a column | 27 Feb 2008 17:31 GMT | 4 |
I want to send out an excel file to some people, but I dont want them to see the column c. I know how to hide a column, That is not what I need, I need to have this column not accessible at all by the people who will receive this file.
|
| how do i refresh random numbers on windows vista | 27 Feb 2008 17:31 GMT | 3 |
on windows xp you could push f7 i think it was and the random numbers would change so if doing a vlookup for example you would get different figures. however in vista i cannot figure out how to do this. pleas help
|
| Cells highlight when dragging mouse : Microsoft, Excel, 2003 | 27 Feb 2008 17:16 GMT | 8 |
When I click on a cell to enter data and then move the mouse after letting go of the button wherever the mouse goes the cells highlight, you can only close excel by shutting it down through task manger. Basically this has rendered all my workbook useless. Any suggestions?
|
| Percentage Issue | 27 Feb 2008 16:57 GMT | 1 |
OK...I've tried to figure this out and I'm not having much luck. I'm trying to set up formulas to figure out the difference in the volume of business at different areas of the resort that I work at. In most cases what I have done works....but in a couple of instances we did ...
|
| IF Text Begins with.. | 27 Feb 2008 16:09 GMT | 3 |
Excel 2003 Is there a way of setting up a logical formula that says =IF (in A1..text begins with "Travel", B1,"")? I have an expenses sheet with a number of different items such as Travel
|
| Excel 2003 Protect file from being deleted | 27 Feb 2008 16:05 GMT | 1 |
I have to put an excel file on a shared drive (I cannot set permissions on the drive)and would like to be able to make sure that it cannot be deleted. Is there a way to protect the file? Thanks for your help.
|
| Formula or Macro | 27 Feb 2008 15:59 GMT | 5 |
I am tired of looking up and typing in each employees pay scale. Their names are always in A and rate of pay in D. How can I solve this. Thank you
|
| Autofill method of range class failed | 27 Feb 2008 15:56 GMT | 6 |
I have an error on the code below. Here is the line that cause the error message. Selection.AutoFill Destination:=ws.Range("A6:" & Cells(6, Columns.Count).End(xlToLeft).Address & ""), Type:=xlFillDefault
|
| Data disappears!! | 27 Feb 2008 15:52 GMT | 5 |
while I'm working with excel, the existing data in cells disappear, stop being seen. I select the rows with the mouse and my data is back! I had the same problem with Excel 2002, however after an office update it stopped. Now I'm using Excel 2007 (office 207 ultimate), I had all ...
|
| public variables | 27 Feb 2008 15:44 GMT | 7 |
When I use ActiveSheet.Copy to copy the current sheet to another sheet, all the public variables or global variables are reset to 0, anyway to avoid this or keep the public variables values when coping ? Thanks.
|
| iPod | 27 Feb 2008 15:22 GMT | 3 |
I am considering purchasing an iPod Classic. Can I use it like a flash drive to upload/download Office files?
 Signature Gary''s Student - gsnu200770
|