conditional formating

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- 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
    - file format question I've created a worksheet for our group to use. However, one of our members has quattro pro. Is there any way to convert to a format that she can use without losing my formulas and such? Thanks. Tag: conditional formating Tag: 770250
  - 2
    - 2D graph with label I'm trying to produce the following graph Program Name Long Leverage Gross M1 23.06% 80.00% M2 23.86% 96.67% M3 25.27% 134.00% M4 25.44% 118.30% M5 27.87% 128.85% M6 28.88% 132.00% M7 32.33% 247.10% M8 36.46% 152.60% M9 42.50% 45.61% M10 45.72% 160.25% I want Long on the X axis, Leverage Gross on the Y axis and for each point (X,Y) I want the Program Name tab next to it. Everything in a scatter plot. Anybody knows how to do that? Thank you much. Tag: conditional formating Tag: 770249
  - 3
    - delete items How do you delete saved items from under recent Documents when you save as it keeps on recent documents how do you delete them Thanks Tag: conditional formating Tag: 770245
  - 4
    - How to open a secured Access db from Excel Hello guys I have been trying to find a solution for this problem in the last 3 days. I have a secured Access database. This db contains a Macro that i will like to run from Excel. I need the code to run the Macro from Excel. Any ideas? Thanks in advance Tag: conditional formating Tag: 770244
  - 5
    - Inserting Hyperlinks I need to insert hyperlinks into excel aiming at movies on my HDD. (Don't ask, its a favour for someone) Which works fine, until I save and re-open the excel file. It appears to be because excel shortens the path and therefore breaks the link. I have tried the Properties, Summary and Hyperlink base fix but find this doesn't work for me. The 'Cannot find specified file' error persists. I have also used =HYPERLINK function with no luck either. How can I stop exel shortening the path? Andrew Tag: conditional formating Tag: 770241
  - 6
    - Variable range column summation and averaging Excel 2003 SP3 WinXP Pro SP2 Header in Row 1 Data starts in Row 2 I'd like to sum [SUM($Fx:$Fy)] a range of cells, n, in a column and obtain their averages [SUM($Fx:$Fy)/n]. My issue is that I'd like to vary the 'n' (cell range) by column so as to compare the fitness of any particular 'n' to another relative to my data and datapoints. So, I've manually setup 'n=4' and 'n=20' and 'n=21'. For n=20, each time I need to manually count the starting point for the summation because the previous 20 cells are blank. Then I need to change each column's 'x and y' [start and end rows] to reflect the new range. How can I setup the formula for the averages so I can just reference a value in, say, Row 1 or 2? Hence, I could have Row 2, Column F be '4' which would then propagate the general formula to start displaying at $F6 for the averages of SUM($F3:$F6)/4? The formula would need to know to start at Row 3 and continue adding through Row 6 and then divide by 4. (Note: Row '6' less Row '3' = 3 then add 1 and I get the value of 4 for the range, if you understand what I'm trying to say here.) I need the logic/formula for the IF(...) and the establish how to do the ROW starting and ENDING points relative to the quantity of datapoints to average. Maybe I'm not too sure how to test what ROW I'm on..... THANKS!!! Tom Tag: conditional formating Tag: 770238
  - 7
    - Help I have a workbook with numerous worksheets in it. Each work sheet has information down colum A. In the first Worksheet i want it to gather all the information in colum A of each persons Sheet. For example. In the main worksheet it will say Employee1!$A$1 in Row 2 Column B. What i am trying to do is copy that formula, but I dont want to have to change the names. Is there a function code that i can do so that it will automatically change the names? I dont know if this makes sense, but any help would be appreciated. Tag: conditional formating Tag: 770235
  - 8
    - Reference every 13th cell from another tab. Is there a formula that will reference a cell in a seperate tab for every 13th cell. For example: In cell R7 it looks at cell =+Equity!E166. Cell S7 needs to be 13 rows below =+Equity!E166... So, R7 equals =+Equity!E166 S7 equals =+Equity!E179 T7 equals =+Equity!E192 I need to repeat this for multiple colums. Tag: conditional formating Tag: 770232
  - 9
    - Bi-weekly date formatting To define a payroll bi-weekly payperiod. ie. 02/24/08 - 03/08/08 Want to enter one date in cell C4. say 03/14/08 I know that the formula =C4-19 will get the start date 02/24/08. I know that the formula =C4-6 will get the ending date 03/08/08. How do you format the two expressions together (with a dashed between) into a single cell: 02/24/08 - 03/01/08 ? Thanks Tag: conditional formating Tag: 770224
  - 10
    - Changing Columns and Rows around to sort Excel 2003 - SP2 I have a spreadsheet given to me by a co-worker. Example: A1 B1 Name John Title HR Department HR This goes down about 1500 rows. 300 some people are listed. Is there an easy way to have the Column become a row. Example: A1 B1 C1 Name Title Department John HR HR Joe IT IT If I could take this sheet and do that it would make life so much easier and I could sort by it. Is there a good way of doing this? Tag: conditional formating Tag: 770216
  - 11
    - How to sort date columns? I have a spreadsheet with the following column headings: Name Occupation Start Date Termination Date The issue that I'm having is that I'm trying to sort by the termination date. Not all employees have a termination date so therefore their row is blank. I need excel to be able to sort by termination date but I also need it to place all people that have a termination date at the bottom of the spreadsheet. I tried to sort by the termination date but it's doing the opposite of what I would like. It places all that have a date at the top followed by the blanks. Is there something that I can do to solve this issue? Thanks for your help Tag: conditional formating Tag: 770213
  - 12
    - how to automatically add row column headings to inserted table? I have inserted tables into Word and/or Outlook. I would like to "turn on" the Row and Column headers so that the table is referenced. Tag: conditional formating Tag: 770211
  - 13
    - Using data from multiple workbooks to generate a report How can I automate collecting information from 30+ workbooks that all have the same format (i.e. Cell B25 in all workbooks has the same type of information) and generating a report or another spreadsheet from the collected information. For example, all of my workbooks contain information about equipment at 30 different locations. I would like to query all of the workbooks and get a list of what is contained in Excel Cell B25. Tag: conditional formating Tag: 770207
  - 14
    - How do I send email addresse from excel spredsheet to aol contact Please help Tag: conditional formating Tag: 770202
  - 15
    - Format Painter I have tried the way it says to extend my formating down the column but it is not working. Here is what I am doing 1. click cell with formatting I want to apply. 2. click format painter button. 3.click and drag mouse to select cells i want to appy the formatting. 4. release mouse button.. It says the formatting is applie to the data in the selected cells. No, it isn't. I go to an empty cell in the worksheet and add data to be used and the formatting is not there. What am I doing wrong. These instructions are from the Microsoft Excel book. Tag: conditional formating Tag: 770199
  - 16
    - Color-coded cell references I've lost the color highlights that show which cells my total refenences when I double click on the total, anyone know how to get them back? Tag: conditional formating Tag: 770198
  - 17
    - importing file into Excel I will be exporting files from Crystal Reports and importing them into Excel. My question is: is there a way i can remove all the Blank rows and Blank columns in Excel in one shot or do i have to delete each line or group of lines? If there is a way to do it in one shot how would i go about doing that? I was thinking of doing a macro but the only problem i see is how would i set up the marco to see if they is any data in any of the rows or columns? Any assistance would be greatly appreciated! -- Thank you, Tag: conditional formating Tag: 770189
  - 18
    - Adding Row on a protected wkbk I have several staff that use wook books (wkbk) to keep track of there clients. The cells with the formulas are protected, because they keep typing over them and then do not know how to put them back in. They often add and delete rows, which I have allowed them to do while still protecting the formula cells. How do I get the formual to duplicate in a row that has been added with out having the formual cell unprotected. -- Lisa M. Tag: conditional formating Tag: 770188
  - 19
    - VBA to split contents of cell I have huge sheet with thousands of non-standard lines of text. Some of the lines have the following line in a cell: ProjID=MFG-Company-DA-33 ProjType=BBAA Uplift=0 CostType=Time Mgr=Smith I would like to understand how to write the VBA that will skip the lines that don't match this format and then Break out the items that do. This is what I have so far. some sort of loop statement here If activecell.value (left(5))="projID" then ' this is where a need the help. I want to move everything after ProjID= to Type= to the next column then move everything after Type= to Uplift= to a column 2 columns away and so on for the rest of the line. else activecell.offset (-1,0) loop End if Thanks for the help. I would use text to columns, but only few of the cells follow the format listed above. Thanks Tag: conditional formating Tag: 770182
  - 20
    - Sumif with multiple columns in sum_range Hello, I have a set of data that has a label in column A the sales in column B, C & D: Column A Column B Column C Joel 500 677 Joel 575 752 Joel 650 827 Claudia 725 902 Tarzan 800 968 I'd like to run SUMIF where the "Range" is column A, the "Criteria" is Joel, and the "Sum_Range" is B:C but when I use SUMIF(A:A,"Joel",B:C) I only get the sum of column B which is 1,725. Can someone hook me up with a formula that can sum both column B & C in this situation. Thanks, in advance Daniel Tag: conditional formating Tag: 770174
  - 21
    - Excel Formula I am trying to get results for cells with dates in them. Who do get the following results: a2 = begining date (3/4/8) b2 = ending date (3/5/8) c2 = difference (1) I do not want (zero) 0 to show up if the cells are blank I do not want a negative number to show if b2 is blank I do want a zero to show if the b2-a2=0 here is the current formula I am using =IF((N73-M73<0)," ",(SUM(N73-M73))) If the M & N are blank I get a zero in O73. I want O73 to be blank If N73 is blank, O73 is also bank. This is OK If N73 & M73 have the same date I get Zero in O73. This OK -- Lisa M. Tag: conditional formating Tag: 770173
  - 22
    - Excel Hyperlink to Worksheet I have embedded hyperlinks in various worksheets which I have then saved as web pages. The web page links will take me to the workbooks but they ignore the worksheet portion of the address. E.g.: this address "MonthlyReport.xls#Summary!A1" will open "MonthlyReport.xls" but it will not take me to the "Summary" worksheet. It seems to default to whatever worksheet I was in the last time I saved the workbook. Has anyone had this problem? Thanks! Tag: conditional formating Tag: 770166
  - 23
    - problem with zip codes and filter I'm trying to sort a spreadsheet by zip code and some zips show as "06901" and others show as "6901". When I sort for one I don't get the other. I tried to manually put a "0" before the the "6901" code and excel will not let me. Which is weird because it will allow it to be imported from another program like that. Is there some way I can format it to get the "0" to show in the column? Tag: conditional formating Tag: 770162
  - 24
    - Wrap text in merged cells VBA I have merged cells that need to wrap text. I used the VBA code several of you provided and it is working great for the most part. The problem I am running into is when I have more than one set of merged cells on the same row. I have applied text wrap to each of them. Let's say I type in several lines of text in the first merged cell unit and it wraps the text perfectly and auto fits the cell. However, if I type only a single line of text in the next merged cell unit in the same row, the whole row autofits to that single line and covers up my multiple lines of text that I just typed in the previous merged cell unit. Any suggestions on what may be the problem? If I need to try to explain further I will. Much thanks! Tag: conditional formating Tag: 770156
  - 25
    - vacation excluding holidays HI I am trying to count the total of leave taken without the holidays and the weekends i have used the NETWORKDAYS but i dont know what is the formula in order to have a total of vacation taken excluding weekends and holidays so this is the table that i have i am using network days but its not working Total =NETWORKDAYS(B17,C17) B= from C=To Holidays B C C52 New Year 1/1/2008 C53 St Maron's Day 9/2/2008 C54 Good Friday - - C55 Labor Day 1/5/2008 C56 Atha's Day C57 Fitr's Day - - C58 MondayEaster - - C59 Independence Day 22/11/2008 C60 Christmas 25/12/2008 PLEASE ADVISE TIA Tag: conditional formating Tag: 770155
- Next
  - 1
    - Date Formula help I am trying to calculate the number of days in a time period excluding Sundays, (i.e., 2/29/08 minus 2/23/08 = 5 ) Can anyone help me? Thanks Tag: conditional formating Tag: 770153
  - 2
    - Link a cell to a word in a sentence I am trying to create work instructions that can easily be modified. I want to link a cell to a word in the middle of the sentence. I have a table with the list of parts and tools, instead of using item 1, 2 ... in the sentence I would like to be able to link a word in the middle of the senctence to the table down below. Thanks Brendan Tag: conditional formating Tag: 770151
  - 3
    - Open Text Files in Excel, Changed Behavior For years I have opened text files in Excel using the right-click "Open With..." in Windows. The files opened without triggering the Import Text Wizard and were imported in one column. As of yesterday (without any apparent changes to Excel or Windows), this behavior changed. Now when text files are opened using "Open With...", Excel "figures out" where it thinks the columns breaks should be. (Again the Import Text Wizard is not triggered opening files this way.) I've searched for settings that determine how Excel opens text files by default, but found none. Any ideas on how to go back to right-click opening the "one-column" text files? Thank you, Patrick Tag: conditional formating Tag: 770147
  - 4
    - Help w/ calculating weekly Avg Hello, I am not sure what formula to use to calculate the weekly average, which is the range of the week data (Monday to Sunday). Example: date range from 2/4 to 2/10/08 week is the sum of data from 2/4 to 2/10 divided by 5 (weekday). Below is a sample of data and results I want to achieve. Data: Type1 Type2 WeekAvg Date ProdA ProdB ProdA ProdB ProdA ProdB 2/4/08 30 10 20 10 61 37 2/5/08 10 15 10 15 61 37 2/6/08 50 15 25 10 61 37 2/7/08 20 10 20 20 61 37 2/8/08 10 10 30 20 61 37 2/9/08 10 15 40 15 2/10/08 20 10 10 10 Result column: WeekAvg for ProdA = 61 (30+10+50+20+10+10+20+20+10+25+20+30+40+10) / 5 Result column: WeekAvg for ProdB = 37 (10+15+15+10+10+15+10+10+15+10+20+20+15+10) / 5 NOTE: 2/9 and 2/10 are weekend so does not need to show value. Tag: conditional formating Tag: 770144
  - 5
    - Formula Help for Duplicate Entries I have a spreadsheet of 3000 contact names I am trying to assign these in the most "fair" fashion to account resps. My thought was to create a colum called "account_rep" I then put account_rep_name1 account_rep_name2 account_rept_name3 In, colum1,Row 1 account_rep_name1 colum1,row 2 account_rep_name2 colum2,row 3 account_rept_name3 colum1,row 4 account_rep_name1 colum1,row 5 account_rep_name2 colum2,row 6 account_rept_name3 the pattern continues respectively through the list to row 3000. However, what has happened is that there may be more than one account rep assigned to an account. For example in the list I have. account_rep_name1 Suzie Queen ABC Company account_rep_name2 Suzie Queen ABC Company account_rept_name3 Suzie Queen ABC Company so, I want to assign unique rep to the account the first time his name hits the account down the list. What is the best way to do this? Thanks, Robert Tag: conditional formating Tag: 770143
  - 6
    - Text overlapping cell border above it When I print from Excel, the text more and more is printing over the cell border above it, the further down it is. How do I prevent this from happening? K Tag: conditional formating Tag: 770141
  - 7
    - Transpose issue I have a series of email addresses from an Outlook email. I want to use Excel's sort feature to sort these email addreeses looking for duplicates. I have attempted to copy , paste special, and transpose to insert this semi-colon separated row into an Excel column. It does not work (inserts as a row) Ideas? Tag: conditional formating Tag: 770140
  - 8
    - Annual leave without holidays Hi I am working as an H.r and i am looking for a formula concerning the annual leave I have already found a formula that gives the total of the days allowed without the weekends But i do need to calculate the days taken excluding the weekends and the holidays A: starting date B: Total of Days allowed C: New Year 31/12/2008 D: Ester 24/3/2008 Etc Please advise Tag: conditional formating Tag: 770137
  - 9
    - Excel file will not open with out opening excel.exe first O3K I attempt to open a file from outlook attachment, file on the desktop, and it does not do anything Right click and open with and it is pointed to open with excel open excel and go file - open and it open fine Thank you in advance Tag: conditional formating Tag: 770134
  - 10
    - Request Hi all. I was wondering if any of you fine excel guru's would fancy taking a look at an Excel book for me and let me know if you could change something. I have a program in excel that creates a rota card for offshore workers. Typically we work 2 weeks on and 2 weeks off ( some 2 on and 3 off). Our rota will change to 2 weeks on and 3 weeks off and I would like to change the VBA to make the program do this new rota. To me, this is an extremely complicated VBA as I manage to muster through VBA with basics. If anyone could or would like to help, could you email me at woody26775@yahoo.co.uk and I can email a copy of it to you. Apologies if i am wrong in doing this, just looking for some help. Tag: conditional formating Tag: 770133
  - 11
    - Not Enough Memory opening 2nd spreadsheet I have 2 spreadsheets each of 24.5MB. If I have one open and try to open the other I get "Not Enough Memory". However my C: has 63.6 GB of avialable memory. Why is this happening and how can I overcome this. Using Office 2000 on Windows XP. -- Regards Pete Tag: conditional formating Tag: 770129
  - 12
    - Current bi-weekly total In my worksheet, Column A1 has project start date and A2 to A3000 has subsequent dates based on A1. Column B has data. After each 14 days, there is bi-weekly total. I would like to add a row on top, which will show me bi-weekly total for the current week. So, let's say, if project start in January 6, 2008, and if today is March 14, I want be able to see the most current bi-weekly total. Is there a way to do that. I was able to do "Year to Date" total by just simply adding those biweekly total. Since, it is a long sheet, I have scroll down to find out current bi-weekly total. I want avoid that. So, the most current bi-weekly total always will be in top row. Thanks in adavance. Tag: conditional formating Tag: 770127
  - 13
    - Hiding Results of Answers for a Quiz Hi, Looking for some help here please. I currently have a quiz set up, with simple questions in the A Column. The delegate places their answer in the B Column, and the C Column then states whether it is correct or not. Used the following formula : =IF(B2="A","CORRECT",IF(B2="","",IF(B2="B","INCORRECT"))) What I need, is for the formula to only be applied once the delegate indicates that they are finished the whole test. (i.e. clicks a cell marked as a "Finished" button). I need to know 2 things: 1. How to set up a cell like a "finished" button for example. 2. How to get the formula not to apply until the finished button has been selected. Any help would be greatly appreciated!! Thanks! Tag: conditional formating Tag: 770126
  - 14
    - Shared document will not open for user Hi, I have a user who is using Excel 2003 on Windows XP. She has a shared workbook that is password-protected on a shared drive. Everyone who has access to the spreadsheet can open it, except for her. It is only this spreadsheet. Her password works fine on other spreadsheets and documents. (This is Excel-level password protection, Tools > Protection >Protect Workbook. ) There is no error message. She enters her password, and a blank instance of Excel opens. Any ideas about how to fix this? Thanks! Kim Tag: conditional formating Tag: 770121
  - 15
    - auto fill rows in Excel 2007 I have a worksheet containing plant information. Each plant has a unique code in column 1. The adjacent cells in that row contain information about that plant (size, color, latin name, etc.) When I create a list for a new job, I'd like to be able to input an existing code in column 1 of a new worksheet (or even blank space in the existing worksheet) and have Excel 2007 automatically fill in the adjacent cells. Any help would be greatly appreciated. Tag: conditional formating Tag: 770114
  - 16
    - Delete duplicates? I have the following code below. How can I include sheet "customers2" also in the code? Private Sub CommandButton99_Click() Dim iRow As Long Dim FirstRow As Long Dim LastRow As Long With Worksheets("Customers") FirstRow = 2 'headers in row 1 LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For iRow = FirstRow To LastRow Step 1 If Application.CountIf(.Range("a1").EntireColumn, _ .Cells(iRow, "A").Value) > 1 Then 'it's a duplicate .Rows(iRow).Delete End If Next iRow End With Unload Me End Sub thank you -- kk Tag: conditional formating Tag: 770112
  - 17
    - Recording Macro Dumb question.... If you have recorded a macro, later wish to add 1 or more steps to it, is there a way to just add to the recording, without having to write or cut and paste code into it? Tag: conditional formating Tag: 770110
  - 18
    - Obtain numeric from alphanumeric string What is the easy method of obtain numeric from alphanumeric string in an excel column:- ab 0.25 I want 0.25 jds 0.125 I want 0.125 Tag: conditional formating Tag: 770098
  - 19
    - Cell Format on Imported Data I have imported data from Oracle (using programing, not import). This is a large file and it brought all numbers over as text. When I choose the column and fomat as number nothing happens. I have to choose each cell change format and enter. This is impossible as there are thousands of numbers to change. HELP.... Tag: conditional formating Tag: 770096
  - 20
    - Finding files in a folder. Variable not defined error. I am getting a variable not defined error on this line "For Each c In lstrng.Cells" and I can't figure out what that means. Any ideas? Set lstrng = Range("A2:A" & Range("A2").End(xlDown).Row) Set fs = Application.FileSearch 'Use Microsoft Scripting runtime. Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder = objFSO.getFolder(UserForm1.txtFolder.Value) 'Check type of file in the folder and open file. For Each c In lstrng.Cells c.Activate If c <> "" Then With fs .LookIn = f .SearchSubFolders = True .Filename = c.Value If .Execute() > 0 Then For i = 1 To .FoundFiles.Count c.Offset(0, i + 1).Value = .FoundFiles(i) Next i Else 'MsgBox "There were no files found." End If End With ElseIf c = "" Then Exit For End If Next Tag: conditional formating Tag: 770090
  - 21
    - Formula for calculating time off My company is going to a PTO or Paid time off program and employees will start to ecru time bas3ed on years of service. I am having difficulty creating a spreadsheet to do this becasue of all of the variables involved. I was hoping maybe you woudl have some ideas here that I could poach. Here are the variables. It is all based on calendar years. So if a person started in 2007 on 12-30, as of 1-1-2007 they woudl be at the rate of 1 year since this is when their anniversary falls. Not only are people ecruing time, but there is also a max time that they can have. I will put in a crude table to expalin. Years Weekly Accrual Max hrs 0 1.538461538 120 1 2.153846154 152 2 2.461538462 168 4 3.230769231 248 Then people will use time out of this banked time. I have formulas that will put the time in, but will not change for the next years eccrual rate. Please Help, Jay Tag: conditional formating Tag: 770088
  - 22
    - consecutive dates i have a scheduling spreadsheet, and need a way of having the dates run consecutively instead of having to manually type each one, i.e mon 03/03 tues 04/03 weds 05/03 thurs 06/03 fri 07/03 mon 10/03 tues 11/03 weds 12/03 thurs 13/03 fri 14/03 and so on and so on, thanks, marie Tag: conditional formating Tag: 770083
  - 23
    - Location of MS Query Application I often use MS-Query 4 extracting data from closed files and run the queries. Where can the MS-Query application be located as I want it's Icon/shortcut 2 be made? Thanx -- Best Regards, FARAZ A. QURESHI Tag: conditional formating Tag: 770082
  - 24
    - Filtering in Validation I am creating a scheduling system for an EMS service. I have a single list of employees (AA:AB) that I can use to create a LIST via validation. AA:AA = Employee Name AB:AB = Certification ie P=Paramedic, I=Intermediate, B=Basic, D = Driver I want to filter based on certification in the validation option so that only paramedics appear for the medic shifts, etc. Is there a way to filter within the validation or do I have to create four separate lists? Thanks, Les Tag: conditional formating Tag: 770080
  - 25
    - Macro - Insert column with VLookups Hi All I need to analyse out a transaction listing based on the account codes. I have set up VLookup tables but I would like to have a macro that would insert the columns with the formulas. The range will be dynamic. E.g. Account Number Insert 1 Insert 2 Insert 3 Amount 111 Vlookup(1) Vlookup(2) Vlookup(3) 222 Thanks in advance Tag: conditional formating Tag: 770073

Hi there

I am created a file to keep track of marks. I want every other line to have
the back ground fill in. Sometimes students names will be added or deleted.
I don't want to have to change the format for each line when a student is
added or deleted. Is there a way to do this?
--
Thank-you!
Ruth

Re: conditional formating by David

David
Fri Mar 14 19:16:56 CDT 2008

CF/ Formula Is ...
=MOD(ROW(),2)
--
David Biddulph

"Ruth" <Ruth@discussions.microsoft.com> wrote in message
news:B83B2A60-3F4C-4599-A8A5-541F1ACC4B49@microsoft.com...
> Hi there
>
> I am created a file to keep track of marks. I want every other line to
> have
> the back ground fill in. Sometimes students names will be added or
> deleted.
> I don't want to have to change the format for each line when a student is
> added or deleted. Is there a way to do this?
> --
> Thank-you!
> Ruth

RE: conditional formating by FSt1

FSt1
Fri Mar 14 19:21:02 CDT 2008

hi
you can use conditional formating to do that. it's called banding.
see this site for detailed instructions.
http://www.cpearson.com/excel/banding.htm

Regards
FSt1

"Ruth" wrote:

> Hi there
>
> I am created a file to keep track of marks. I want every other line to have
> the back ground fill in. Sometimes students names will be added or deleted.
> I don't want to have to change the format for each line when a student is
> added or deleted. Is there a way to do this?
> --
> Thank-you!
> Ruth

RE: conditional formating by Ruth

Ruth
Sat Mar 15 11:26:00 CDT 2008

Thank-you very much!
--
Thank-you!
Ruth

"FSt1" wrote:

> hi
> you can use conditional formating to do that. it's called banding.
> see this site for detailed instructions.
> http://www.cpearson.com/excel/banding.htm
>
> Regards
> FSt1
>
> "Ruth" wrote:
>
> > Hi there
> >
> > I am created a file to keep track of marks. I want every other line to have
> > the back ground fill in. Sometimes students names will be added or deleted.
> > I don't want to have to change the format for each line when a student is
> > added or deleted. Is there a way to do this?
> > --
> > Thank-you!
> > Ruth