| Thread | Last Post | Replies |
|
| Stop Circular Reference Help Notices | 19 May 2006 18:02 GMT | 2 |
Is there a way to stop the Circular Reference Help to keep on popping up when I create a formula that is indeed circular reference? I have a whole bunch of formulas every now and then that I need to correct and it creates a circular reference. Now I am aware of where its happening
|
| Convert Hard-coded cell values to constants | 19 May 2006 16:38 GMT | 2 |
Gang - If you have not guessed, I manage deer - lots of them in lots of counties. For that reason, I'm trying to automate my population models. In short, what I've developed is a simple accounting-style
|
| Showing negative balances in red | 19 May 2006 16:10 GMT | 3 |
I've set up a spreadsheet for eBay sales, but prior to any sales having been made it shows negative balances, what with listing costs and so on. How do I get it to show those negative balances in red, reverting to black when a credit balance is achieved?
|
| How I do this formula ? | 19 May 2006 16:07 GMT | 3 |
I would like to format all words that said “customer” in a column to chosen color.Can anyone provide a formula or conditional formattin that will do this
|
| Advanced filter exclusion | 19 May 2006 16:03 GMT | 2 |
I would like to create an advanced filter criterion that works in reverse; in other words, it doesn't select rows BECAUSE they contain a specified value, it selects all rows that do NOT contain a specified value. For example, if I have a column that contains any of the 26 ...
|
| Formatting Pivot Table Item Row Totals | 19 May 2006 15:27 GMT | 2 |
Is there a way to automatically have the item row totals appear in bold while the detail remains unbold? For example, if I have a Pivot Table that displays the following data: State City Total
|
| conditional formatting | 19 May 2006 15:12 GMT | 5 |
I have a row with 3 cells. The last cell will contain a date. When that cell is filled in, I want all three cells to turn green. I can do the formatting for the last cell but do not know how to do it
|
| macro novice | 19 May 2006 13:46 GMT | 4 |
Help I need to convert a large number of phone numbers from one format to another in order to have them all the same. When I run a macro I get the formatting changes however running the macro
|
| Time inputted as minutes and seconds Excel | 19 May 2006 13:14 GMT | 3 |
When inputting time that is in minutes and seconds I have to use a decimal and a zero. i.e. mm:ss.o. Can I reformat so I can input as mm:ss
 Signature EDba
|
| Macro security level | 19 May 2006 12:40 GMT | 1 |
hello friends i need a VBA thats tests the macro security level and if it is up t low level to make the marcro security level is low --
|
| Format a worksheet based on column widths of another ? | 19 May 2006 11:50 GMT | 2 |
Can this be done ? I am importing data form txt files produced by an old dos program and I want every sheet (holding an imported txt file) to have columns the same widths as other shetts I have already formatted.
|
| Need keywords and index in Office help file. Online help no good | 19 May 2006 11:15 GMT | 1 |
Online help can be annoying unless you know the exact words and phrase to type. If your searching for help and unsure what to type you end up with lots of useless suggestions. It was alot easier to determine what help may be usefull when a person could view and index and keywords ...
|
| Date count | 19 May 2006 10:42 GMT | 1 |
Hello everybody :-) Let say I have these data: Centre Name Date Open Santa Maria August 2004
|
| Probability of a streak??? | 19 May 2006 09:21 GMT | 4 |
I tried to implemented it by myself but found it impossible. I went to Help and searched for Monte Carlo simulation. Read everything what I've found about it, but again, no results. Probably I did the wrong search. I'll put it this way: If there is X% probability of event A ...
|
| How do you keep your toolbar customized the way you set it up? | 19 May 2006 08:20 GMT | 2 |
I have used different versions of Excel for years; we are now using Excel 2003. I have customized my toolbars the way I want them several times but they won't stay the way I set them. I read about autosensing - I don't know if that affects it. Can I make the toolbars stay put?
|