| Thread | Last Post | Replies |
|
| tough condtional formatting question | 13 Jul 2006 20:25 GMT | 4 |
Gang, I spent the last hour searching through some 600 posts on conditional formatting. I found some elaborate solutions, but I'm thinking maybe I'm asking too much with the following:
|
| Excel Format Cells | 13 Jul 2006 20:20 GMT | 3 |
How do I format a cell so that it blinks
|
| Greater Than / Less Than Problem | 13 Jul 2006 20:10 GMT | 11 |
Don't want to sound silly here, but I am actually having a problem with a formula that will allow me to count only values greater than 0 but less than 11. Is this Possible in 1 unique formula? Heres the situation:
|
| linking worksheets | 13 Jul 2006 19:58 GMT | 3 |
How can i link to an entire worksheet in another workbook, so tha changes may be made to the worksheet ragerdless of which workboo containing the sheet is opened? Thank
|
| Excel not prompting for save on exit | 13 Jul 2006 19:34 GMT | 1 |
A co-worker has had something happen to his excel settings that is causing Excel not to prompt him to ask if he wants to save his work when he closes a spreadsheet. I have searched in vain for the setting that controls this. I am sure that this is something very simple that
|
| Conditional Format - Date | 13 Jul 2006 18:50 GMT | 1 |
I have a question that I home y'all may be able to help me with: I am trying to use Conditional Formating for some dates. What I want to do is have only certain dates to be in bold and older ones not to be. ie., if I am entering dates for June on a spreadsheet for the month of ...
|
| normal.dot | 13 Jul 2006 18:48 GMT | 4 |
Hi is there an equivalent to normal.dot in excel. Everytime I open a blank excel spreadsheet I get a macro warning but I cannot find any macros. Office/Excel 2003 and windows XP pro with SP2 Thanks Ron
|
| mileage sheet shortcut | 13 Jul 2006 18:09 GMT | 1 |
I have a mileage sheet that needs to be coded per person at work. So C12 is where the person types their name. A seperate spreadsheet has all company employees listed along with the code that needs to be added. What I would like to make happen is that the name typed in would ...
|
| Find invalid names via VBA | 13 Jul 2006 17:40 GMT | 5 |
Using VBA, how do I identify invalid dynamic range names? For Example, I would like to flag the following: "TargetRng" is defined as OFFSET(StartPoint, 0, 0, 1, 100) where "StartPoint" is undefined.
|
| [Qry] [OT] After open Excel 2K3 it closes immediately | 13 Jul 2006 17:17 GMT | 2 |
Sorry for cross-posting and of-topic (maybe people in W2K/XP news could solve this problem). Excel was working without problems for many time but I have great surprise today because when I open Excel it closes immediately. No error or window is
|
| Weird Text Formula Request??? | 13 Jul 2006 17:14 GMT | 3 |
In my worksheet, there is a column which has the name of the 1s applicants and the 2nd applicants all in one string. The majority o records are separated by an “and”; MR CT Blah and MRS OP blah. Th other half of the records is separated by a large space;
|
| FORMAT SECTIONS OF CELL FORMULA DIFFERENTLY | 13 Jul 2006 16:22 GMT | 3 |
My cell formulas have gotten fairly complex and I was wondering if there is a way to perhaps format sections of the formula differently to make it easier to read. For example, maybe bold everything before the "+" and underline or something after.
|
| Need formula to calculate time difference | 13 Jul 2006 16:16 GMT | 3 |
I am certain there is a really simple way of doing this and I am just too stupid to figure it out... I just want to have Row 1 Column B show a start time I manually enter (say 9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to show a
|
| multiple worksheet formula help | 13 Jul 2006 15:53 GMT | 3 |
I have a 7 page workbook. Page 1 is the "master" sheet containing formulated data from the other 6 sheets in the workbook. Each of the 6 other sheets are set-up with the exact same rows and columns - they are simply assigned to a different sales representative. I have the ...
|
| Track Each Time Macro is Played | 13 Jul 2006 15:43 GMT | 1 |
The macro I have created needs to be logged. I need to know how to track the date and time the macro was run.
|