| Thread | Last Post | Replies |
|
| Format based on result of formula against another sheet | 06 Nov 2007 20:10 GMT | 2 |
I'd like to use conditional formating based upon the value (True or False) of the equivalent cell in another sheet. Can I do this without resorting to VBA? GB
|
| Formula help | 06 Nov 2007 18:59 GMT | 1 |
Hello, I have a form in my excel workbook that is brought up by a buttons on click event. On this form I have 5 text boxes. 1) txtMinutesWorked 2) txtRunMinutes
|
| Excel 2007 & XP/Vista | 06 Nov 2007 17:34 GMT | 1 |
I hope this is the right newsgroup for this posting, my apologies if not. If I open a workbook in Vista (which also loads Common Macros.xlsm via XLSTART) and then open another workbook this also opens the same instance of Excel. However, if I then try open a workbook in an email ...
|
| Can't send an attachment in Excel 2007 | 06 Nov 2007 17:27 GMT | 9 |
Hi, I've had several versions of Excel but I am new to Excel 2007. I've had no problem sending a worksheet as an "attachment" until 2007. I did figure out that instead of File, you now have to press the pretty
|
| Enter Range | 06 Nov 2007 16:49 GMT | 3 |
I have a list of data in Column B, and I need a formula in column A that returns either dependant on what the cell value is in column B. Needs to return on of the following '<31', '31 - 60', 61 - 90', '91 - 180', '>180'
|
| How can I display doubles | 06 Nov 2007 16:15 GMT | 3 |
I have a worksheet with over 15,000 lines. I would like to be able to retain only those lines which occur two or more times and simply get rid of the rest. Any ideas? Your input is greatly appreciated.
|
| Formatting Cells.. | 06 Nov 2007 15:58 GMT | 3 |
I have an XLS sheet that we use to make invoices for samples we send to our sales reps. We use the same XLS sheet, but save it renamed on our network with that customer name and date, just changing the data on the sheet. On the right hand side are two columns marked Line Price and ...
|
| time to decimal | 06 Nov 2007 15:28 GMT | 2 |
I have numbers like 283 hours 13 min 7 sec 283:13:07 in an excel work sheet. I want to convert this to decimal minutes. What formula can accomplish this?
|
| Change to classic menus | 06 Nov 2007 15:20 GMT | 1 |
I have searched the site and probably wasn't using the right terms so only found one thing about this: I have been using Excel 2007 and office for a few months now. The menu is almost worthless and I am about ready to move to an open source product. Is it possible to convert the ...
|
| Spinbutton | 06 Nov 2007 15:16 GMT | 2 |
I would like to use a spinbutton on a userform. I can get the button to work well going one way but can not seem to get it to go the other way. Ex I would like to button to produce an acending number while clicking on one side of the spinner and decending while clciking the other ...
|
| Can anyone suggest a way out of this dilemma? | 06 Nov 2007 14:50 GMT | 5 |
I work for a state government agency which is currently working on its annual report, mostly consisting of Excel tables of how well other state agencies are doing in meeting their Equal Employment Opportunity (EEO) targets. I posted a few days ago for advice on how to round
|
| Graph Points | 06 Nov 2007 13:58 GMT | 5 |
I have a graph with 40 points I am trying to enter the apexs values (high & low) in cells next to the chart. Not having any luck with "=if(and(c3>c4,c5,c4,c5,c4),if(and(etc.
|
| vba code for inserting formula | 06 Nov 2007 13:07 GMT | 5 |
I just can't make my code work. If have different text in B2:B632 that, based on what the text is, needs to write a formula in G2:G632. There are about 30 different text's in B, and they are names of Named Ranges. I was trying to write:
|
| Cells print so small I cannot read numbers. How do I fix? | 06 Nov 2007 10:19 GMT | 1 |
I have been working with page break. Now I have the grid on 1 page..but it is far to small to read. now when I try to spread it back to 2 pages, it just takes the same tiny microscopic type and spreads it into 2 pages. I am stuck printing tiny type. How can I get the grid cells ...
|
| Auto protection of cells | 06 Nov 2007 07:09 GMT | 4 |
I have the Dates in Column A , I want to protect the cells in Cloumn B , based on todays date .This needs to be done automatically w/o going to format cells , protection . How to do that ? I mean noone can make any entry to the date other than Today's date
|