| Thread | Last Post | Replies |
|
| flashing cell | 27 May 2007 13:16 GMT | 3 |
Is it possible to build something that would have a cell blink/flash/change colour if a cell reached a certain figure? Example...I enter hours worked into the cells in Column A..once an an employee reaches a certain amount of hours we give them specific benefits....it would be ...
|
| How do I return the cell location | 27 May 2007 13:09 GMT | 4 |
How do I return the cell location (in addition to the value contained in the cell) of the maximum value in an Excel array? I'm trying to locate the row number for the maximum value in a column of numbers.
|
| Future date Calculation | 27 May 2007 12:24 GMT | 8 |
My one cell have today date with formula =Today() and i want total remaining day in Numbers from any given future date. Exp. I put in one cell 30/5/2007 other cell have 31/12/2007 and the result should be show in numbers how many remaining day from today to till last day of give ...
|
| Excel Dates | 27 May 2007 11:49 GMT | 11 |
Can any one advise me on the following. How do I create a simple spreadsheet to return dates from a set criteria. Example I want to enter a start date, then the number of weeks of the period (i.e
|
| How do I set the default comment format and view in Excel | 27 May 2007 05:38 GMT | 1 |
I have a very large file containing several worksheets. Many of the cells have comments which I don't want displayed all the time (only on mouse rollover). I would like to set the default format and view for future comments as well as discover a quick way to reformat all the ...
|
| Conditional or Indirect fill up | 27 May 2007 03:49 GMT | 5 |
I'm trying to get a formula ( 1st choice) or conditional formating that will do this : When writing a number or text in A1 for example, another word of my choice will fill B1. No macros unless there is no other choice please. Thanks.
|
| Protect an Excel WorkSheet from being deleted | 27 May 2007 02:10 GMT | 5 |
I have a blank WorkSheet called "Scratch" in an Excel workbook with lots of VB code. I want the user to be able to do anything with the blank WorkSheet called "Scratch" except to Rename it or to Delete it.
|
| Excel running Word macro | 27 May 2007 01:19 GMT | 2 |
I have a complicated macro which does several things to a series of imported htm files, however it is not working as expected. An excel macro produces a list of htm files within a directory and outputs it to sheet1 and then one by one uses this as a parameter to
|
| Checking a cell has correct formula | 27 May 2007 00:56 GMT | 13 |
I want to put values in cells A1 & B1. I then want to type a formula into cell C1 to add up A1 & B1. I want cell D1 to check that the formula in cell C1 is correct and to display a relevant message, e.g. correct or incorrect. What is the easiest way around this? Thanks
|
| Why does my file name show %20s instead of spaces? | 27 May 2007 00:55 GMT | 4 |
Whenever I save a file from Excel to a floppy disk it adds "%20" instead of spaces. Is there anyway to keep this from happening? Thanks!
|
| how to have result of excell formula remian as if inputed | 27 May 2007 00:07 GMT | 1 |
having made a spreadwheet with formula. results are reflected. how to kave the result follow when copying and posting worksheet to another workbook as if the results was initially inputed.
|
| Why doesn't While ActiveWorkBook <> Null work? | 27 May 2007 00:05 GMT | 3 |
I load a random number of csv files into Excel anywhere from 10 to 50 Excel shows that each csv file is loaded as a different workbook. each workbook only has one worksheet I want to execute a sub on each workbook and then write the created sheet and
|
| Read-Only Limits | 26 May 2007 21:49 GMT | 2 |
I currently have a spreadsheet out on our network, does excel limit the number of people that can open a spreadsheet in read-only mode? I am trying to figure out if these is an Excel limit or a network limit. Any ideas?
|
| Change Defalut Template for Excel 07 | 26 May 2007 21:01 GMT | 1 |
I am currently running Excel 2007 and would like to change the default template when excel opens. Also, how do you change the template excel uses when you hit the "new" icon button? If you can't change it, is it possible to create an icon that would
|
| Sorting is Incomplete | 26 May 2007 19:30 GMT | 13 |
Trying to sort 3 columns (last name-first name-birthday) by birthday. Excel sorts correctly but only the first 82 rows. It leaves the last 20 rows unsorted. How can I get it to sort the entire worksheet?
|