coloring font

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - WEEKNUM function returns #name in Excel 2003 I have Excel 2003 installed. When I enter a WEEKNUM function into a cell I get #name returned. When I do a check on the formula Excel help tells me there is an unrecognized entry. Basically my formula looks like this in cell C5 I have =weeknum(A5,1) in cell A5 I have the date 12/08/2003 I'v done fourmulas for the date in A5 to break out the year, month, and day, then re-assembled them with 'date' forumla to make sure it's a valid date and to get a date serial number, but however I have the dates entered, the weeknum formula doesn't work. It's as if the function is an invalid function to begin with, but I found the formula in Excel's help files. Has anyone else experienced this problem? And does anyone have a solution? ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: coloring font Tag: 25351
  - 2
    - userform question Hello, I am a novice to VBA and Userforms and I'm stuck. Please help? I have a userform which populates an annual 'orders worksheet' using VBA with date, customer, product, and location. Using named ranges from 'customersdb' worksheet I am able to fill the sources for each combobox on form except the locations. Some customers (col B) may have one or up to six locations (Cols C:H). These locations listed on customersdb WS are in multiple columns but are in the same row associated with the customer. Col ___ B_________ C _______ D _______ E _______ F_______ Row Jim Smith Battery Park South Central Train Stop Main Street How can I fill the 'location' combobox2 to just list the locations for the customer chosen in the 'customer' combobox1 while still in userform? Any help would be greatly appreciated, thanks!! --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25344
  - 3
    - Does anyone have a spreadsheet that can . . . Does anyone have a spreadsheet that can make a list of all the songs in my mp3 music folder? I would love to have it emailed to me, if you have one post here that you have and I will send you my email address. Thanks Russ Tag: coloring font Tag: 25334
  - 4
    - Extra rows at bottom of spreadsheet After removing a large number of rows from the bottom of a spreadsheet I can no longer reach the end of the data by pulling the right scrol bar to the bottom. It ends up at the end of a large number of blan rows. Any idea how to correct this. I want to be able to grab th right scroll bar, drag it to the bottom, and be on the last row of m data. Thanks for any help -- Message posted from http://www.ExcelForum.com Tag: coloring font Tag: 25332
  - 5
    - List function Hello, happy christmas, Can someone have a list of financial function, i would like to have it all ! thank you Philippe, Alliel, Sitel pour l'assistance utilisateur Microsoft Tag: coloring font Tag: 25328
  - 6
    - Revised Query: Suggest some solution Dear Experts, Consider the following example & provide any best possible formula. In a Working File: --------------------------------------- Column A Column B --------------------------------------- 1 Product Name Sales_Units 2 Product "a" 2220 3 Product "b" 5175 4 Product "c" 395 5 Total Value ?? ==> This is cell 'B5' To get the Total Value, the price for above products are listed in a seprate sheet "Pricelist", among other 100s of products. Pricelist: --------------------------------------- Column A Column B --------------------------------------- 1 Product Name UnitPrice 2 Product "a" 20 3 Product "g" 75 4 Product "c" 95 5 Product "t" 15 6 Product "b" 25 6 etc.... etc.... The required formula or method have to find each product i.e. Product "a", "b", "c" in "Pricelist" & then multiply its "Sales_Units" by its "UnitPrice" and then give total value of all products in cell "B5". I am expecting an answer in cell 'B5' is 211,300 Kindly note that this formula or method should be a global one i.e. I can use this formula on other sheets or file. Any Suggestions Thanks for your understanding! Murtaza Tag: coloring font Tag: 25326
  - 7
    - Number to text format problem A very simple task normally i know - but i need to convert a 12 digit ean reference from number to text format. When i do this through the normal route of formattting the whole column it changes to 4.00511E+12 - obviously the ean ref to the power of 12 and rounded up! Why??? The cell size is not a problem. Hitting F2 to enter each cell and tabbing out will show reference as i need it, but this will take me all day for a 70,000 line SS. Any ideas!? --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25325
  - 8
    - Finding duplicate numbers Is there a way to make a macro or something that will search through an excel sheet and see if there are any duplicate numbers. Thanks for any help --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25318
  - 9
    - Importing large tab-delimited text files? I deal with very large data sets that are in tab-delimited .txt format. Many times, there are more than 256 columns of data. The Microsoft Knowledge Base had an article titled "Sample Macro to Import Data with More Than 256 Fields or Columns". This could do the trick for me if I could modify the macro to accomodate tab-delimited formats. Q1: Could anyone tell me how to modify the macro described above for tab-delimited .txt files? Q2: Does anyone know of a bulk file conversion utility that would change a tab-delimited text file to a CSV format? Thanks a bunch, Mark R-S Tag: coloring font Tag: 25310
  - 10
    - Creat a spreedsheet with moving rows? I am firefighter who has been given a project that I hoping someone here can help me with. I have worked with Microsoft Access quite a bit, but I think Excel is better for this project. I have made an inventory progam in Access that seems fairly complicated, to me at least. So my BC was hoping I could put something together for an overtime staffing list. I do not know VBA. Below is brief summary of what I am trying to accomplish. We have 3 separate personnel lists from which to hire overtime when nessasry, one for each rank of Captain, Operator, and Firefighter. People are listed in order of when they last accumulated 24 or more hours of overtime. The most recent person to accumulate 24 hours of overtime will be the last person on the list. When an overtime coverage is needed the BC (battalion chief) will go down the list and offer overtime to people that are available to take overtime. The person first on the list may be working that day or on annual leave or for what ever reason can not work that day. So the BC continues down the list. When he finds a person to accept the overtime, it may be a full shift, 24 hours, in which case they will go to the bottom of the list from where ever their current position on the list is. If the overtime is a partial, say 10 hours, then they will not move from their current position unless they have previously accumulated 14 hours or more and therefore putting them over 24 hours. At which point they will be moved to the bottom of the list. Once you are moved to the bottom all hours are reset to 0. This a can be a very lenghthy proccess for the BC. We currenty are using a card file but mistakes can be made trying to track hours and positions. This is an example: Name "Accrued Hours" "Accepted Hours" Smith " 0 " " 0" Johnson "10 " " 0" Jones " 0 " " 0" White " 0 " " 0" When the BC offers someone hours (Accepted Hours), they will be added to (Accrued Hours). Once Accrued Hours have equal or exceeded 24 that person will be rotated to the bottom of the list. If Smith accepts a 14 hour overtime he does not move because his Accured hours will then be 14. If Johnson accepts 14 hours he will move to the bottom of the list and then his Accured hours will be rest to zero. I know I am asking an impossible question. If anyone can help I will really appreciate the assistance. Thanks for your time. Mike Tonner Firefighter Sparks NV --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25302
  - 11
    - Excel VBA programmer needed Programmer needed visual basic, in excel I own a bee removal company . I keep most my records and calcualtions in excel and I am looking for an excel specialist / vba programmer that can write code to simplify and speed up some of the time consuming tasks. Time is a factor for me, money is less of a factor. I imagine it would be around 80 hrs work. With probable future changes and or additions that would most likley arise. Example: Bee removal work can be divided into two parts, 1 exterminating a hive, and 2. removing the honey from the structure (from 5 to 300 lbs). The field rep exterminates the hive and sets the appointment for the removal. The technicians remove the honey from the structure and perform repairs. I am looking for someone in Southern California. If interested please contact me at: > >adkins@san.rr.com > >john adkins Problem Right now I pay a sales rep 20% of the exterm fee and nothing for signing up the removal. I've created a macro that calculates each field reps exterminations for the week, removals, averages per job etc, and calculates the money the field rep earned. Its a little crude but it works. Im trying to encourage the reps to focus on closing more removals, this way I make much more money. As an incentive, I plan on breaking up the 20% (for the kill) to a percentage for exterminating (the kill), and a percentage for setting up a removal. I don't have the time to design this, neither would I do a good job at it. Basically the macro would do something like this: for employee field search for "NW" then find desired dates within date serviced field, then take a % from exterm fee, add it to desired % for removal (if any) matching the desired pay period or dates. to come up with the amount to pay NW for the 2 weeks. as well as more accurately gather data for that period totaling # of exterms, repairs, ave per job, etc. so for every job Nick W 'NW' did during a inputted period of time, I would have a detailed analysis as well as the amount to pay Nick. A field rep is in either a level 1, 2, or 3, depending on past performance. A level 1's % of pay is less than that of a level 3. This is the first time I've written this information up so you may have trouble following it as I've explained it. But this is one example of data that I'm looking for at the click of a button. There are 5 to 10 other similar equations or macros which I would need to have written up. Also with hopes that the code would be able to sit well in upcoming versions of excel. Tag: coloring font Tag: 25301
  - 12
    - secure Help please I want to keep all my personal information in an Excel file, how secure is a password protected Excel file, or what other simple method is there? Mike -- Please Reply to News Groups Only. Thank you Tag: coloring font Tag: 25300
  - 13
    - excel hangs - mouse movement automatically highlights cells as it moves... I have a user having a very wacky problem. She'll be working fine in Excel 2002 with the latest updates , then out of the blue she looses control of selecting cells with the mouse. It appears to randomly highlight multiple cells, deselecting cells. You cant even close down excell at this point. You have to kill the application. This is a dell laptop with an external ps2 mouse and an Alps track pad. I've updated the bios on this Dell 8200 running XP Prof and I've upgraded the Alps trackpad drivers as well. This seems to happen 3,4 times a day. She states that it happens whether or not she has the external ps2 mouse connected or not. Any thoughts? TIA Tag: coloring font Tag: 25298
  - 14
    - if, then statements and alpha variables I want to have Excel return 1 if the value is e and -1 if the value is w. I can do this with the logical IF statement if the variables are numbers but it doesn't work if the variables are letters. any suggestions? --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25293
  - 15
    - Applying one code block to the sheet that calls it Some of you may recall my various questions re: unhiding columns & rows. Now that I have a code that works on Worksheets("PayPeriod_01"), I'd like to have the code respond to each of several sheets. For the purposes of our 2 week pay period, there would be 26 or so pay periods. Rather than have to copy the code 25 times, and doing a search / replace to change the sheet number, is there a way of having the one code block be called by a copy of the button, but use a variable on the sheet ( 01 , 02, 03, ... 25, 26 ) to ... 1) change the sheet name ( PayPeriod_01 , PayPeriod_02 , PayPeriod_03, ... ) 2) change the range name that determines the rows to open for that sheet ( Empls_Per_01, Empls_Per_02, Empls_Per_03, ...) 3) change the range name that determines the columns to open for that sheet ( Jobs_Per_01, Jobs_Per_02, Jobs_Per_03, ... ) I would guess that each sheet would have a cell with its' number ( 01, 02, 03 ... ) Or should a new button on each sheet define the 3 variables, and then call the rest of the code? Thanks for the help. Brian ===================================================== My complete code to date ... Private Sub CommandButton1_Click() 'This part opens 3 rows for each employee, in 1st & 2nd weeks Dim RowRange As Range Dim r1 As Integer, r2 As Integer, r3 As Integer, r4 As Integer Set RowRange = Worksheets("Select_Employees").Range("Empls_Per_01") For r = 1 To 19 If UCase(RowRange.Cells(r, 1)) = "X" Then r1 = 48 + (2 * r) r2 = 48 + (2 * r) + 2 r3 = 298 + (2 * r) r4 = 298 + (2 * r) + 2 Worksheets("PayPeriod_01").Rows(r1 & ":" & r2).Hidden = False Worksheets("PayPeriod_01").Rows(r3 & ":" & r4).Hidden = False End If Next 'This part opens 2 columns for each job in progress Dim ColRange As Range Dim c As Long Dim c1 As Integer Set ColRange = Worksheets("Select_Jobs").Range("Jobs_Per_01") For c = 1 To 100 If UCase(ColRange.Cells(c, 1)) = "X" Then c1 = 3 + (2 * c) Worksheets("PayPeriod_01").Columns(c1).Resize(, 2).Hidden = False End If Next c End Sub Tag: coloring font Tag: 25285
  - 16
    - Microsoft Excel Why can't I close my Excel application by clicking the x button in the upper right hand corner of the application. This is Excel 2002. Is there a way to do this? --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25282
  - 17
    - More than 2 "Custom Autofilter" conditions? Is this possible?! (ms Excel2002) Excel 2002/Win2000 Hi Anyone know if there is any way to use more than just *two* filter condtions in the (extremely useful) custom AutoFilter?! Is this possible? with thanks Ship Shiperton Henethe Tag: coloring font Tag: 25275
  - 18
    - saving multiple sheets as separate files Hi, I am excel 2000 user. I have a workbook with 15 worksheets. Each of the sheet correspond to an employee and contains some information. I would like to create 15 separate files from each of the sheet, so that i can send them to each employee. Is it possible to do this automatically ? regards hari --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25274
  - 19
    - reference data of other workbook When I write a formula, I reference data of other sheets using sheetname!rowcolumn. How could I reference data in other workbook. Is it workbookname!sheetname!rowcolumn or something like this? My appreciation for your answer. bingy@sina.com Tag: coloring font Tag: 25271
  - 20
    - Help ! formatting data to text I am creating data in an Excel spreadsheet. I then want to get that data into a simple text email. I have some problems and questions... 1) how do I get the columns of data to line up evenly when I copy the data to email text ? Keep in mind I need to be in simple text format, not HTML or rich text. Every time I do this, all columns become chaos and are unreadable. 2) Is there a simple way to automate the creation of an email from an excel file ? this is less important to me. Thanks in advance WxMachine Tag: coloring font Tag: 25269
  - 21
    - Image set transparent becomes opaque on clicking it I have a Gif image and to try making it clickable I placed the Excel Image Control on top of a specific part of the image I want to make clickable and set the backstyle to Transparent for the the Excel Image control (Image1). So far so good I have created a device handler to throw a messagebox for the Image1_Click event handler when I click the Image it turns opaque I am setting even explicitly Image1.BackStyle = fmBackStyleTransparent in the Image1 click event and despite it the Image still remains opaque. This is driving me nuts not sure where I am missing something please help. Thanks Simon Tag: coloring font Tag: 25263
  - 22
    - How to create transparent objects on images in Excel Hello All John Walkenback said in one of is articles on clickable images is to place a image and place transparent objects on the image and write event handlers for the transparent objects to create clickable images. Please find John Walkenbach's article on this topic here: http://www.j-walk.com/ss/excel/tips/tip41.htm NOTE: Another way to create an image map is to insert transparent objects over the image, and create event-handler subroutines for the objects. I have a country map and want to insert transparent objects and write event handlers for them I have created buttons and I cannot set them transparent can of you please share your thoughts on how I can create transparent objects. Many thanks Simon Tag: coloring font Tag: 25262
  - 23
    - No Text Shadow option Using Excel 2002, Win XP. I have all the buttons on the Formatting toolbar showing, yet there is no Text Shadow option. Any suggestions will be appreciated. Thanks in advance. Stan Tag: coloring font Tag: 25258
  - 24
    - need help printing on a form How do i print a list addresses that i have saved in excel on a form from like an address book. i dont know how to arrange the address name etc... manually before printing. --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25250
  - 25
    - How do I link information in the LAST ROW of a workbook to another?? Hi all! :) I'm new here, so if by posting this message directly, I'm not following procedure, appologies ahead of time. I'm trying to link information from one workbook to another. It's for inventory. We have a different page for each item number, and every time the item is adjusted, it adds a new row to the speadsheet. I want to be able to list ALL the totals from the different pages into a new file, so people can see totals by looking at ONE sheet. The problem is, the row number of the cell I need changes everytime the source file is edited. There doesn't appear to be a formula that says something like, -Returns a value or reference of the last cell in a particular column- Is this possible?? Thanks!! - Grant Henry --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25248
- Next
  - 1
    - Excel 2002 opens fine but Excel 2003 "File error: data may have been lost." I have a spread sheet that's about 10MB large. I try converting it to a .XML spreadsheet from a computer running Excel 2002, but during the conversion it crashes. Any suggestions? Tag: coloring font Tag: 25246
  - 2
    - Calculating values for empty cells. Hello. I have a very simple problem that I cannot find the answer to. I have data in two columns, some of the data in one of the columns is missing and I want to automatically extrapolate what the data should be based on the trend. How can I get Excel to fill in empty values without overwriting the known values. Below is a sample of my data. 1500 1600 1700 1800 4000 1887 5700 1900 5500 1910 7300 1912 8100 1920 8800 1926 10100 1930 11900 1936 12200 1938 -- Ryan Taylor rtaylor@stgeorgeconsulting.com Tag: coloring font Tag: 25245
  - 3
    - Excel is screwy I have a Vlookup, works fine on absolutely everything except for one aspect. I have a Vlookup table which returns the latest animal born in a zoo (I create these things to keep me amused), it works fine for every entry except one (belfast). wierdly though if I copy "belfast" from the lookup table and paste it as the lookup value it works fine....but not if I type it. Anyone else met this problem? thanks, Danny Tag: coloring font Tag: 25242
  - 4
    - attach custom toolbar to spreadsheet: how? Hello, For a client I have made some macro's to speed up things in a spreadsheet. I have created a custom toolbar, and attached the macro's to newly created buttons. Then I attached the toolbar to the spreadsheet. However, If I open the spreadsheet on another workstation for the first time, the toolbar is opened, but no button is defined on it. I have also troubles to get my macro's starting on the workbook. So my question is: -how can I create a custom toolbar that is attached to a certain spreadsheet -the toolbar should be opened automatically when the spreadsheet is opened -the toolbar should be deleted if the spreadsheet is closed (toolbar commands are NOT available to other spreadsheets) Is this possible? How? thanx in advance, bart plessers -- HyperART Paul Van Ostaijenlaan 4 3001 Heverlee Tag: coloring font Tag: 25240
  - 5
    - Got error message - Cannot open lotus 123 file! My problem is rather strange. Both computer has *exactly* same versions of Excel installed. One of them can open *exactly* the same .wks file while the other cannot. The error message is quit simple: Cannot open lotus 123 file. Does anyone else have had such problems? Tag: coloring font Tag: 25236
  - 6
    - Filtering out information Just wondering if there is any way of applying a filter to remove certain segments. E.g. filter out everyone called Jones in a list so that all other names are left on the sheet except Jones Thanx in advance, Cat Tag: coloring font Tag: 25233
  - 7
    - Entering Absolute Cell Location In A Formula Hello All, When I enter cell addresses into a formula, I can simply click on a cell, to have that cell's relative location added into a formula ( = C1 + D2). I want to click on the cells and have the absolute location added into a formula (=$C1 + $D1). Is there a combination of <CTRL> or <SHIFT> etc. that will do this? Thanks a lot in advance. Regards, Alton Tag: coloring font Tag: 25225
  - 8
    - cannot open message Using Excel 2003 under WinXP Pro When opening Excel I keep getting a message: cannot open Add_ in for editing, edit the source file instead. When I uncheck the add in box and re open the message goes away. Does anyone have any suggestions? My installation on this machine was office 2000, then office XP and now Office 2003. TIA -- Peter Tag: coloring font Tag: 25223
  - 9
    - Excel hangs on start up I have MS Excel 2000 and it is hanging during start up when you start it from an icon. If you click an XLS file then it gives the "fatal exception 0E has occurred at 017F:BFF9DFFF" blue screen. It says it is low in memory when it starts but the system has 256 MB RAM and 94% free. nothing is running in the background except explorer and maybe systray. I have renamed the msoffice.exe, msohelp.exe and the mso9intl.dll, and did a repair. No help. I uninstalled, then reinstalled, no help. I installed a second version, this time a small business version rather than the professional, in a new directory, no help. I am out of ideas. Any help out there is appreciated. Jose Tag: coloring font Tag: 25222
  - 10
    - Copy and paste dont work When I try to paste with the right button on some cells the paste menu is enable and on other cell is disable... do you know why it do that? --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25217
  - 11
    - Hyperlink help I'd like to hyperlink from an index worksheet to a location in another worksheet - say, AB-2847 - and have that cell (AB-2847) appear in the upper left-hand corner of the screen. Is that possible? Thanks. Warfighter Tag: coloring font Tag: 25215
  - 12
    - Tab Key not working Hi, I am looking for some help. I have just created an Excel work book using MS office XP Pro and protected a work sheet. I have defined a range of fields that any user can input data, however on this work sheet the Tab key will not allow the user to tab to the next field. Any suggestions on haw to get the tab key to function Thanks Ian Tag: coloring font Tag: 25210
  - 13
    - Page Break Is there a way (either by macro [least favorite] or conditional formatting [preferred] or formula [also preferred] to set up page breaks based on data rather than number of lines on a page or the excel defaults. e.g. Let's say A:A contains names and I want to force a page break every time the name changes. I can set up B:B with an indicator that the name changed if necessary, but cannot seem to find a way to set the page breaks other than to do it manually. Thanks in advance. Tag: coloring font Tag: 25203
  - 14
    - Print Titles won't appear as wanted I really need help for this problem. I already fill in row number 1-3 a my print titles in the page setup menu but everytime i print out m worksheet row number 5-7 always on top instead of 1-3. Anyone please help -- Message posted from http://www.ExcelForum.com Tag: coloring font Tag: 25202
  - 15
    - Open Excel from Win Explorer Hi I have WINXP SP1 and have just noticed that for XLS files I cannot directly open files from Windows Explorer. I get a message "Unable to read file" But I then click TWICE and it opens fine - and not in a read-only form either. Can someone point me in the direction of how to fix this please? TIA Ron Tag: coloring font Tag: 25201
  - 16
    - 2003 vs previous version Hi, I use MSNStockQuote functions in 2002 version. Now, it seems no longer exists in 2003. I can use the smart tags, but it works entirely differently. Wonder if anyone knows if I am missing something or MS does it again, like the new ASP.net does not back support ASP...! -- thanks in advance for your input, EM Tag: coloring font Tag: 25198
  - 17
    - Conditional, Conditional Formatting Two questions, both have to do with semi-complex (at least for me) conditional formatting. 1) I have two conditional formatting "formulas" on column B. Depending on the corresponding row in column I, I want the conditional formatting on or off. If I3 = 0, then don't allow conditional formatting for b3. 2) I want cells from column A to be "strikethrough" if the corresponding cell in column I equals zero. Is there any semi easy (from a data entry standpoint) way for this to be accomplished? Thanks, John Tag: coloring font Tag: 25187
  - 18
    - Perplexed with Countif I have a column with a number of text entries, the range is B2:B7844. One of many entries in the column is Green Valley. To count those cells with Green Valley entered, I have used the Countif function. The exact formula is =countif(B2:B7844,"Green Valley"). The formula is returning a result of 0 (zero). What is wrong with my formula. The format was originally General, and I have tried to reformat as Text, with no change. I am using Excel 2002. Tag: coloring font Tag: 25183
  - 19
    - Help absolute cell reference problem I have a master workbook with three worksheets; a summary worksheet and two detailed data worksheets. The summary worksheet currently has formulas that contain relative references to the other two worksheets. I would like to be able to copy the summary worksheet to other workbooks but keep the referencing within the new workbook. When I copy the summary worksheet now the formulas reference the data worksheets in the original workbook. ie. Workbook "1" has the summary worksheet "A" and data worksheets "B" and "C" I create workbook "2" which has new data worksheets but are still called "B"and "C" I want to copy summary worksheet "A" from workbook "1" to workbook "2" and reference worksheets "B" and "C" in workbook "2". (Currently when I copy worksheet "A" it still references data worksheets "B" and "C" in workbook "1") Can I do this? I have played with absolute referencing but this only seems to lock the cell reference, not the worksheet reference. Thanks in advance.. Tag: coloring font Tag: 25173
  - 20
    - Please help solve these mysteries (Excel columns, etc.) Thank you for the suggestions. Upgrades are completely at the discretion of the IS department (and they won't acknowledge the problem and are not Excel users). I'd love to hear from anyone who's had this problem and has solved it. In the archives (Google Groups) I found 3 or 4 similar questions going back to 2000 but no solutions were posted... Re: the double document icon - that's what I thought (and still think) it is. I just need to know the "secret" to getting it to let go. I tried every key, key combination and location for this. No luck. Perhaps if I knew it's MS official name, I could find it in the help section..... Thanks again. In article <3FE1DBC3.4E1D9C96@msn.com>, Dave Peterson <ec35720@msn.com> wrote: > About the column problem: > > Some posters say that upgrading to SR2 helps. But others have said that it > had > no effect. You can check to see what version of xl97 you're running under > Help|about. > > The double document icon: It kind of sounds like it's the cursor you get when > you click (or ctrl-click) on a worksheet tab to move (or copy) to a new > location > in the workbook. > > Maybe the mouse stuck down. Without being too harsh, try gently banging on > the > mouse keys--include the scroll wheel button, too. > > Maybe even gently bang on the keyboard (maybe the ctrl keys are stuck). > > But be careful--don't break anything. > > > > D Warcken wrote: > > > > I had, I hope, a temporary problem with Excel today. I've been using > > this computer and program for about a year at my job. It has Windows 98 > > and Office (Excel) 97 and I have not had any problems with it at all > > until the past few weeks. Our IS updates things on our computers from > > time to time and we recently had some network printing software and > > cables installed. > > > > I opened a file that has multiple worksheets (7). Using the Edit menu, > > I created a copy of the last sheet and moved it to the end. The columns > > in the new worksheet were all wrong (much narrower than in the > > original). I deleted that worksheet and tried again 2 or 3 more times > > with the same result. I closed and reopened the file. Now ALL the > > original worksheets had narrower columns. I selected all of them and > > fixed them all and saved. When I closed and reopened the file the > > columns were again narrower than they were supposed to be. I did this > > several times, even entering some text in one of the cells. The text > > was saved but not the column width formatting. I opened a new file and > > changed some of the column widths to something other than the default. > > When I closed and opened this test file it also had changed to narrower > > columns on the ones I had changed. I also tried Save As and doing the > > same operations with the copied file. Same result....I closed all the > > files including the original one, leaving the columns narrow. I > > restarted the computer and, lo and behold, the column widths in my > > original file had reverted to the original (correct) widths even though > > I had closed and saved them in the incorrect configuration. What do you > > suppose was going on? I asked our IS if the problem could be RAM or > > harddrive related. They didn't think so. Should we reinstall Excel? > > Another person in the office had the same problem a few weeks ago and > > it has not resolved itself. > > > > I have had two other problems with this program recently. A couple of > > times a "double document" icon (looked like two little pieces of paper > > stuck to the arrow cursor) has appeared attached to the cursor and > > there didn't seem to be any way to get rid of it or even to find out > > what it was. I asked several people in the office and no one knew what > > it was. We eventually had to do the Control/Alt./Delete to quit Excel > > (that worked). The other problem only happened once. I had about 50 > > worksheets in one file and it would not let me make another one. Using > > the Edit menu I tried to copy a sheet and place it at the end of the > > worksheets. When I clicked OK it closed the menu window but did not > > create an additional sheet. I couldn't find anywhere where it said > > there was a limit on the number of sheets and, in any case, I have > > another file that has the exact same sheets (except for the data) that > > has 93 worksheets. > > > > Any insight and/or solutions would be appreciated. > > > > Deborah Warcken Tag: coloring font Tag: 25171
  - 21
    - Create a PDF file fromt a workbook file Hello, I need to create a pdf file from a workbook file using code. I know how to do it by printing to PDFWriter or Distiller, but I was hoping there is a simpler way. I noticed that the Acrobat installer added a button to the Excel commandbar for converting to PDF. I tried recording a macro while doing a conversion, but there was nothing in the macro so I guess Adobe is using one of their PlugIns, as usual. Any help would be appreciated. Ragnar Tag: coloring font Tag: 25169
  - 22
    - Importing an Access Database into Excel I was trying to find out if there is a downloadable add-in for Excel that will give you Microsoft query capability. I hace Excel 2000 but I cannot open an Access file due to not having the 2002 version. I was told that I needed to go through the process of 1) hitting Import External Data then 2) Clicking new Database Query. I then get the message that I must first install the optional Microsoft Query. How can I download/install this optional Microsoft Query? Thanks for any help! Jeff Tarlton --- Message posted from http://www.ExcelForum.com/ Tag: coloring font Tag: 25163
  - 23
    - Printing a dynamic print area I have a worksheet that uses external data, refreshed each time I open. The print area has to be reset each time so that the empty rows with formulas in the cells aren't printed. Not knowing the amount of data that will be inserted, I copied the formulas up to row 200. This gives me plenty of room for the external data, but I don't want all of the empty rows in my printout. Any ideas? Alex D Coker Home:901.861.2818 Fax:901.861.2459 Mobile:901.870.5615 Tag: coloring font Tag: 25156
  - 24
    - Safe way to check what is in a cell Hello, I am writing an application that is supposed to parse a spreadsheet file into individual files dependent on what is in the first column. Each block of rows with the same numeric string or number is used to create a new file, i.e. a change iin number signals end of a file. Lines with anything else are to be ignored. For this reason, I need to check the first column for one of the following: 1. A string of numerals, f.ex. "014" 2. A number, f.ex. 610 3. #N/A 4. Blank 5. Anything else So, I need a safe way to tell if I have either 1 or 2, or one of the rest. I have code that handles 1, 2 and 3 right now, but then I tried another sample and found blanks instead of #N/A. I am thinking now that I should first check for #N/A, then retrieve the contents into a Variant variable and check for blank. If it is neither, check variable if it is numeric. If it is I have my numeric string, otherwise it is a 5. Are there any possible surprises in this? Any help would be appreciated. Ragnar Tag: coloring font Tag: 25155
  - 25
    - Colouring excel sheet tabs Just wondering if anyone knows of a way to colour the bottom tabs of an excel worksheet. Is there a macro i can use to colour them? Again, any help much appreciated regards Neal -- Tag: coloring font Tag: 25153

Dear all,
I want to format a cell based on the value of anothe
cell. For example, I want the color of the text in one cell to be re
if the value in another cell is "Y". How could I acheive this.

Please advice

--
Message posted from http://www.ExcelForum.com

Top

Re: coloring font by J

J
Fri Dec 26 04:11:21 CST 2003

Take a look at Conditional Formatting in XL Help.

In article <kubimaibam.z1h2a@excelforum-nospam.com>,
kubimaibam <kubimaibam.z1h2a@excelforum-nospam.com> wrote:

> I want to format a cell based on the value of another
> cell. For example, I want the color of the text in one cell to be red
> if the value in another cell is "Y". How could I acheive this.

Top

Re: coloring font by Norman

Norman
Fri Dec 26 04:21:41 CST 2003

Hi kubimaibam!

Assuming the cell that governs format is A1:

Select the cell
Format > Conditional Format
First drop down select "Formula is"
Type: =A1="Y"
Format
Select your choice of format
OK
OK

Note here that I've used relative referencing for A1 if you choose to
copy
Note also that the Y has to be in quotation marks or Excel will start
looking for a cell named Y

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"kubimaibam" <kubimaibam.z1h2a@excelforum-nospam.com> wrote in message
news:kubimaibam.z1h2a@excelforum-nospam.com...
> Dear all,
> I want to format a cell based on the value of another
> cell. For example, I want the color of the text in one cell to be
red
> if the value in another cell is "Y". How could I acheive this.
>
> Please advice.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Top