coloring rows “if” true
I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...
Answer Question
| May 16 2008 8:17 PM GMT
| asked by
Tstychalski
Excel 2003, Conditional expressions, Microsoft Excel
Problems oprning Excel File
I have been working with an Excel 2003 workbook since January 2008 and from last week began having difficulty opening the file. Whenever I attempt to open it, I get an error window with the following messages shown in bold below:[Excel found unreadable content in 'filename.xls'. Do you want to...
View Answer
| May 1 2008 8:53 PM GMT
| asked by
EB
Excel, Excel 2003, Microsoft Office
Saving chart colors in excel 2003
When I set chart colors in an Excel 2003 spreadsheet, save and reopen the spreadsheet, the color reverts to previous colors. I have tried creating a macro but this do not work. Can someone please advise me how to do this task?
Answer Question
| May 1 2008 3:44 PM GMT
| asked by
Kattydavis
Excel 2003
Excel 2003 - How to sum up a chart with percentage
I have created a worksheet to track when letters are sent out. I have a column (1) for the name of the recipient and a column (2) for the date the letter was sent. How do I track what percentage of the letters have been sent?I would like a graph/chart, either bar or pie, that will tell me how...
View Answer
| Apr 8 2008 8:29 PM GMT
| asked by
Milelle
Excel 2003
Convert spreadsheet into a flat file
I need to convert a spreadsheet into a flatfile using the mid function. I only want to use a couple fields out of the spreadsheet, can someone help me?
View Answer
| Apr 8 2008 3:13 PM GMT
| asked by
Kioh46
Excel 2003
VBA Auto Protect
How can I make the worksheets in Excel automaticaly protected on date
View Answer
| Apr 7 2008 10:21 AM GMT
| asked by
Georgesal001
VBA, Excel 2003, Visual Basic for Applications
Validation in Excel
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.
View Answer
| Mar 27 2008 4:15 PM GMT
| asked by
Mart802
Excel, Validation, free type
Switching custom views in Excel when filtering
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it...
View Answer
| Mar 27 2008 3:13 PM GMT
| asked by
Tsbarr
Microsoft Excel, Excel 2003, Excel macros
Switching views in Excel when filtered
I have several macros that switch views for a very large spreadsheet. I also have filtering available for the various columns. However, whenever the view is switched, the filtering is turned off. If filtering is on, I would like the filtered view to not change. Is there a way to keep the filtering...
Answer Question
| Mar 26 2008 3:45 PM GMT
| asked by
Tsbarr
Excel 2003
While Loop in Excel VBA
I have the basic loop and can not figure out what to write in the middle.I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far:Private Sub Loop1()Dim myLoopCtr As IntegermyLoopCtr = 0While myLoopCtr <= 15myLoopCtr =...
View Answer
| Mar 21 2008 10:34 PM GMT
| asked by
Castaway1958
VBA, Excel 2003, Visual Basic for Applications
Excel Date format () dd-mmm-yyyy error from exported crystal report
I am exporting a crystal report file to excel and date field TRADE_DATE is coming out strange. i.ePARTY_ID TRADE_DATECX () 16-Jul-2003CX 29-Jul-2003CX 09-Dec-2003Some trade_date fields are in Custom Type "dd-mmm-yyyy" format ( which is the correct format) but some are in Custom Type "()...
View Answer
| Mar 19 2008 7:30 PM GMT
| asked by
Shakeel45
Crystal Reports, Excel 2003, date format () dd-mmm-yyyy error
Excel RTD and userform
I need to read data from the spreadsheet into userform anyone can explain it to me?whenever i call the userform the cell stop from being updated/
View Answer
| Mar 5 2008 2:44 PM GMT
| asked by
JonsIL
VBA, RTD, Excel 2003
Excel - Question
How can I copy multiple selections in Excel worksheet
View Answer
| Feb 22 2008 2:44 AM GMT
| asked by
Nadeemzuhair
Excel 2003
Shift Differential
How can I write a formula for shift differential if 06:00-14:00 is normal working, 14:00-22:00 is $1.00 more an hour and 22:00-06:00 is .90 more an hour?(A5 Work Hours ) (B5-Sunday start) (C5- Sunday End) (D5- Monday Start) (E5- Monday End) etc.Thanks you to any one that can help.
View Answer
| Feb 22 2008 2:11 AM GMT
| asked by
Bradyman699
Microsoft Excel, Excel 2003
Excel 2003 Cell has formula but empty Value or text
HyaI have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing.I have usedisblankisempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is empty or...
Answer Question
| Feb 19 2008 8:17 AM GMT
| asked by
JonsIL
Excel 2003, NULL
Excel cell referencing across worksheets
In the past I used to be able to caculate a cell reference on another worksheet in the same spreadsheet and get the value(contents) and use it in the worksheet that was referencing out, but this feature seems to have disappeared. At present I am using Excel 2003.Any suggestions?
View Answer
| Feb 18 2008 6:18 AM GMT
| asked by
Ianh
Excel 2003, Microsoft Excel


