Shading of Multiple Rows in a Pivot Table

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Worksheet
- 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
    - Email files What I would like to do is have an excel file email my work email when the conditional formating has been reached. I want to create a spreadsheet that will track training in house and after a 3 month, six month, 9 month, and 1 year time frame, i would like the spreadsheet to email me this speadsheet at these intervals. I dont know if it is also possible to have it only email the individuals that have reached to time frame limits, not newly added individuals. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505868
  - 2
    - Summing a Column - Net and Absolute Values I've got a column of positive and negative numbers that I want to total in two ways : - net - ie just natural addition which I can do with the SUM formulae - absolute - ie the total being based on an assumption that all numbers are positive A slightly messy way (because of the design of the spreadsheet) is to create an extra column of absolute values and sum that. So my question is 'Is there are formulae I can use to do an absolute sum on those values directly?' TIA Rob Tag: Shading of Multiple Rows in a Pivot Table Tag: 505855
  - 3
    - pivot table help I've got a (non-pivot) table with 5 columns that looks like this: HRG POD yr1data yr2data yr3data HRG and POD are categories, and the figures in the 3 data columns are the values of interest. I want to have HRG as the rows, and then I want 3 main column headings: yr1data, yr2data and yr3data. however, there's only 5 possible values for POD, and I want each of the 3 data columns split into 5 subcolumns, each headed by a value of POD. I can get the pivot table with HRG as rows and POD as columns, but I only seem to be able to add the data by subdividing rows rather than columns, even when choosing 'column area' in the 'add to' drop down. any suggestions gratefully received Tag: Shading of Multiple Rows in a Pivot Table Tag: 505853
  - 4
    - Is it possible? Hello, I wonder if it is possible to make a sheet work in tally chart form? I have satisfaction questionnaires that come to me periodically. I want to know if it is possible that excel can, rather than use '1' as the answer, add this to whatever was in there before? For example: Cell contains I type in Automatically it adds together 3 2 =5 If not any suggestions on the easiest way I can record this information? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505850
  - 5
    - count unique in non-continuous list Hi, Is there a way to count unique values in a list that is not continuous and contains merged cells? I have a list in one column which regroups data (numbers) in several categories and each value can occur in several categories. And there are merged cells as well. How to count the unique entries over the entire list? The functions mentioned in the numerous posts here do not seem to work. Thanks, Hans Tag: Shading of Multiple Rows in a Pivot Table Tag: 505848
  - 6
    - data validation my data validation in the series of cells i "validated" with a list is there, when i check through edit>goto>special>data validation, but the drop down arrows don't show in that series of cells. what am i doing wrong? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505839
  - 7
    - Can anyone assist me with a new workbook template for Excel 2003? I have reloaded all of Office 2003, repaired Office 2003, reset all worksheet options that I am aware of, and cannot get fill color or font colors to display in a worksheet. Also, I have reset display settings numerous ways and removed updates to no avail. Additionally, I have followed Office instructions to remove sheet.xlt and book.xlt, but never found either file. I have tried resetting XP options which I really don't understand. This has been going on for several months and is really causing problems and frustration. If you can offer suggestions, please contact me asap. Thank you in advance. Kelly Tarbell - kellyjotarbell@live.com Tag: Shading of Multiple Rows in a Pivot Table Tag: 505834
  - 8
    - Find Earliest Date Hello, I have 2 dates, not in any order. I would like to create a formula to give me the earliest date of the 2. Example: A B C 1 Date1 Date2 Result/Answer 2 4/20/08 1/20/08 1/20/08 3 2/28/08 5/10/08 2/28/08 4 5/7/08 2/14/08 2/14/08 I thank you in advanced for your continued support. -- Respectfully... Elaine Tag: Shading of Multiple Rows in a Pivot Table Tag: 505830
  - 9
    - Logical Test I have extracted text data format thus i cant perform any maths calculation on the data. Thus i tried this logical test to convert the data into number. cell A cell B cell C cell D cell E Cell F 4101001 NET SALES/PRODUCTS 172.641 172 641 172,641 4102001 NET SALES/MERCHAND. 641 641 0 6410 Cell C should read as 172,641 and 641. Since the value is text format, firstly i tried to pull the interger from 172.641 and mod .641 and which later combine these two result into number and reads as 172,641. i write this formula on respective cells, Cell D =INT(+$"Cell C")*1 Cell E =IF(+$C7>1,(MOD(+$C7,1)*1000)) Cell F= =(+O7&P7)*1 note *1 in formula to convert the text to number somehow, if the value in cell C is only 641, the result in cell F is 6410. Anyone can suggest the solution for a formula to suit these 2 situation? thanks in advance 4102001 NET SALES/MERCHAND. 672 Tag: Shading of Multiple Rows in a Pivot Table Tag: 505828
  - 10
    - Insert a drop down list into an excel cell, linked to Access I need to insert a Drop-Down list into an Excel 2007 worksheet cell, with the data linked to an Access 2007 database. Can anyone advise please? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505827
  - 11
    - Excel queries Hi; Appreciate if someone could help me with this: I have a spreadsheet that contains a column for the user to indicate whether they want to "Update" or "delete" the request. Please advice whether the following can be done: a) When the user enter the value called "update" in the cell, then the excel should automatically change the wordings in that row to "blue" color b) When the user enter the value called "delete", then the excel should strike through the whole row for me Thanks in advance. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505821
  - 12
    - How to get the result with IF function Hi, Kindly advise how to get the result in return with the following condition A B 12 10 B value must be =>1 but =< 15 will be result A value, otherwise 0. Thanks Tag: Shading of Multiple Rows in a Pivot Table Tag: 505820
  - 13
    - Pivot tbl rpt-how to return text in a field vs. a sum/count value New to pivots & discussion groups - please be kind! Trying to use a pivot report for scheduling. On the spreadsheet I have columns for calendar days and another column called projects. Each row on the sheet will have a project name in the "projects" column and the volume for the project is entered & repeated in the columns for each calendar day the project is planned to run. Want to be able to show all of the project names that are planned into each Calendar day but also want to see only the projects names planned for each day. I have all of the Calendar columns in the row area of the report and I was hoping there might be a way to return the text in the C&F field for each of these calendar columns? Expect to have several hundred projects planned over a few months. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505815
  - 14
    - Lookup Issue I have a problem that I require help on. I am working on a big spreadsheet. I have to pull information from one sheet into another. However I have 2 lookups to do. Is this possible. example - Info Sheet A B C 1 Manchester ABC Total -230.30 2 Manchester DEF Total +123.34 Example - Working Sheet A B C 1 Store Name ABC Total DEF Total 2 Manchester I need to lookup "Manchester" and "ABC Total" to give me "-230.30" in a cell. Any Ideas if this is possible, or another solution!! Thanks in advance Jayz Tag: Shading of Multiple Rows in a Pivot Table Tag: 505812
  - 15
    - pivot table filtering not working I have a cube that I am accessign from Excel 2007 pivot table. I have a date dimension that I need to filter on in my reports, but excel is not completely seeing this column as date values. It will tell me to apply a date filter, but any filter and combo of values I use blanks out my entire result set. When I use the revers boolean logic, I get the entire result set back, nothing filtered out. When I select indvidual values from the multi select box, that filters everything ok, and when I use the canned "All dates in the period" section, that filters the data as expected as well. But of course I need to be able to filter starting in the middle of a month and end in another month. Any ideas on how to either get Excel to treat the data as a Date value so it will filter correctly, or force a lable filter up so I can use that? thanks in advance!! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505806
  - 16
    - how to keep a running tally of boxes filled with info Hi, I use a spreadsheet of Excell 2007 to keep track of dates that different individuals work. There are about 150 persons and everytime they work a day, I put the date in the next sequencial box to the right of their name. I need to keep a running total of the total number of boxes filled in. Any suggestion on how to do this? Thanks! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505803
  - 17
    - Need to copy I am constantly added worksheets to my excel file. How do I copy all info including the column widths to another worksheet? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505802
  - 18
    - Invisible Formatting ? or ... ? I have some cells formatted in blue font & green background on my worksheet. Is there a way for conditional formating, or some other way, to make them invisible ? I need to provide most of the data on the worksheet to others, but I don't want them to see those blue/green cells. I know I could manually format them as no-fill with a white font, but I was hoping to make it automatic, or even possibly with a macro. Any help or assistance would be greatly appreciated. Thanks, Steve Tag: Shading of Multiple Rows in a Pivot Table Tag: 505799
  - 19
    - Multiple cell value I am using a formula and it has 2 or 3 different cells, it like as follow: cell A1: January, A2:CH now I want to take a formula to use those two cells as a combine like, Index($B4:$I9000,Match(cell("contents",$A$2),$B$4:$B$9000,0),2) --this is my original formula now I want to change and put down a two matching cells like A1 and A2 in the formula... How can I do this? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505798
  - 20
    - Two-variable Data Table - Problem with result/output Hi all. I'm having a problem with a two-variable data table. I have verified that I correctly have a formula driving the data table, and my 'base' inputs for the two variables are hard-coded in the table. I have multiple data tables in my workbook and all but this one seem to be working correctly; the table I'm having the problem with is essentially an Earnings Per Share table (specifically, what happens to EPS if the company repurchases X number of shares at X buy-back price--the # of shares repurchased and the share buy-back price are the variables). The Row output seems to be correct - EPS decreases accordingly based on # of shares repurchased (as it costs us more $ to buy more shares, therefore, EPS should decrease); however, the column output (EPS based on buy-back price) is staying the same at all levels of the # shares purchased, when it should increase as the # shares repurchased increases (because there will be less shares outstanding to split up profit between). I cannot figure out why this is not working...help. Tried to paste the matrix below for your reference, but the system was not letting me (rec'd a message stating 'inappropriate text found in text' !). Tag: Shading of Multiple Rows in a Pivot Table Tag: 505791
  - 21
    - Making formula results not visible in a cell In my "total" column I don't want the results of the SUM to show up if there is not an entry in the cell to the left of the SUM cell. -- MPS Tag: Shading of Multiple Rows in a Pivot Table Tag: 505786
  - 22
    - intercept and slope functions I'm using Vista and Office 2007. I have formulas using intercept and slope calcs, but they are now coming up as DIV/0. Thre are no "0"s in the list and I have the addins activate. What am I missing Tag: Shading of Multiple Rows in a Pivot Table Tag: 505783
  - 23
    - gathering multiple spreadsheets into one I have 2 worksheets (2 individual XLS files) that I need to bring together into a single worksheet. The first column of each spreadsheet is the "persons" ID number. I want to append the in worksheet 1 with the data in worksheet 2, based upon the ID number. The data in worksheet 2 is a mix of text, number, phone number, etc. Is there a single formula I can use to bring it all in based upon the ID numbers in column A? eg. WS1 WS2 123|Mark 157|trans|(201)646|2008 Event|Yes 124|Harry 123|mortg|(732)995|2008 Event|No 129|Dave 762|rund|(676)423|2007 Event|Maybe 129|mortg|(212)123|2008 - Trip|Yes 124|party|(919)222|2006 - Trip|No DESIRED RESULT IN WS1 123|Mark|mortg|(732)995|2008 Event|No 124|Harry|party|(919)222|2006 - Trip|No 129|Dave |mortg|(212)123|2008 - Trip|Yes Tag: Shading of Multiple Rows in a Pivot Table Tag: 505773
  - 24
    - VALIDATION while playing around, i did something that seems to have disabled my "data-validation" drop down list in a range. it seems to have something to do with auto fill. can anyone perhaps help? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505766
  - 25
    - Cell insertion if values not matching Thanks in advance for your help! I have created a spreadsheet to inventory equipment that have GPS units - I need help in working through some formatting or Macro, ??? I have placed my master equipment listing in Row B The exported GPS listing Equipment number in Row C If they match - Row A has conditional formatting to indicate color Green & 'Verified' What I need is if they do not match - If row C > row B, insert blank cells in row on columns C,D, & E and shift cells down to continue the verification process thru the entire 400 piece listing. -- Thanks! Susan Tag: Shading of Multiple Rows in a Pivot Table Tag: 505765
- Next
  - 1
    - IF Function with ISBLANK Hello, I'm hoping someone can figure this out. I am trying to add a value to B1 using the following: I started out with =IF(ISBLANK(A1),"",8) A1 will either be blank or contain a date. As an example I want to change the above so that if I enter in A1 the date of May-7x the the value in B1 will return a 4. And if I enter the date of May-7z into A1 then the value returned in B1 should be 8. So to summarize, B1 should either be blank, contain a 4 or contain an 8. I think the key is that I need to define a wild card (if possible) to look for either the 'x' at the end of the date to bring back '4' or a 'z' at the end of the date to bring back an '8'. Its a bit confusing to explain, hopefully you can understand. -Thanks Tag: Shading of Multiple Rows in a Pivot Table Tag: 505763
  - 2
    - lookup/match mult values SHEET 1: (lookup Values) COL A - House # COL B - Group Name SHEET 2: (lookup Vectors & Array) COL C - House # COL D - Group Name COL E - Amount (RETURN VALUE) I want to use a lookup formula of some sort to match the row from Sheet 1 using information from Columns A&B. Then match it with the rows in Sheet 2 that have the EXACT matching information in Columns C&D, and then return the value from Column E. For example, Sheet 1: COL A COL B 1486 Yellow2 Sheet 2: COL C COL D COL E 1486 Blue1 97 1486 Yellow2 26 So I would like the return value to be 26 (not 97) Tag: Shading of Multiple Rows in a Pivot Table Tag: 505762
  - 3
    - Formula problem I have the following formula to calculate a persons age based on todays date in one column and their DOB in another, but I need to modify the formula so if no DOB is listed, the formula returns a blank. Currently a blank in the DOB column calculates to 108. =DATEDIF(M2,K2,"Y") I need to add something to this so I get a blank, not 108. HELP!!! Thanks Tag: Shading of Multiple Rows in a Pivot Table Tag: 505757
  - 4
    - Reference sheets I am setting up a spreadsheet that I need help with. In the first column, I want them to choose their name from a list of about 80 names. In the 2nd column, I want them to choose their role from a list of 6 roles. In the next 3 columns, I want them to choose their mentors, but the list of choices is determinant on what they chose for their role in the 2nd column. Can anyone please help with how to set this entire spreadsheet up? Thank You! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505755
  - 5
    - new cell for each day I am trying to use the date cell in one workbook to determine what cell of another workbook that I pull. so if today is the 6 then it will pull cell g12 in another workbook. =+'[Apr MIR.XLS]Mid-City'!INDIRECT("g"&$a$44+9)) -- Libby Tag: Shading of Multiple Rows in a Pivot Table Tag: 505752
  - 6
    - problem summing columns with dates I have a table where I am summing columns containing date information. The table looks like: E F G years months days 1 2 9 0 5 6 29 0 0 0 6 2 total 32 2 0 the years, months, days information is found by the following formulas that Pete_UK showed me last week (thanks again Pete the formulas they work great). FYI (A9 is beginning date mm/dd/yyyy and C9 is ending date mm/dd/yyyy years - =DATEDIF(A9,C9,"Y")+IF(DATEDIF(A9,C9,"YM")+IF(DATEDIF(A9,C9,"MD")>=14,1,0)>10,1,0) months - =IF(DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"md")>=14,1,0)>=9,0,DATEDIF(A9,C9,"ym")+IF(DATEDIF(A9,C9,"md")>=14,1,0)) days - =IF(DATEDIF(A9,C9,"md")>=14,0,DATEDIF(A9,C9,"MD")) The problem I am now encountering is this: When the days column >=15 days I am to add 1 to months and then return 0 in 'days total' or >=45 days then add 2 and then return 0 in 'days total', else return sum total of column C; then when the months column is >=9 then add 1 to year and return 0 unless the total months is between 13 & 16 then you would add 1 to year and return the difference between the total months-12 (you would then repeat this process for each multiple of 12 months (add 2 years and then return months; if total months are between 9 and 12 you return 0 to months total) or if total months is < 8 then return sum of months column I have shown, in the example above, what the total should look lilke but have been unable to get it. This really has me stuck. Thanks for any help LAMP Tag: Shading of Multiple Rows in a Pivot Table Tag: 505746
  - 7
    - Formula problem I am having problems coming up with a formula Here is my scenario If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in Column B Tag: Shading of Multiple Rows in a Pivot Table Tag: 505740
  - 8
    - If Question I am looking for a formula in ColC that will return TRUE is the right character in COLA is 0 (zero). ColA ColC 123 FALSE 120 TRUE Thank You in Advance. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505728
  - 9
    - new cell each day How do I create a formula to pick a new cell each day of the month. If today is the 6 and I want to reference cell g12 and on the 7 I want to reference cell g13 and so on. -- Libby Tag: Shading of Multiple Rows in a Pivot Table Tag: 505727
  - 10
    - Calculated Fields and Pivot Tables Assume that I have a Pivot Table that looks as follows: Jan-08 Feb-08 Mar-08 Apr-08 Total Client 1 10,000 11,000 8,000 14,000 43,000 Client 2 0 2,000 500 100 2,600 Client 3 5,000 4,500 0 0 9,500 Client 4 15,000 15,000 13,000 8,000 51,000 Client 5 3,500 5,000 7,500 9,000 25,000 33,500 37,500 29,000 31,100 131,100 I would like to have the Pivot table to produce results like this: Jan-08 Feb-08 Mar-08 Apr-08 Total Client 1 10,000 11,000 8,000 14,000 43,000 % of Prior Month 110.00% 72.73% 175.00% % of Current Month 29.33% 27.59% 45.02% Client 2 0 2,000 500 100 2,600 % of Prior Month #DIV/0! 25.00% 20.00% % of Current Month 5.33% 1.72% 0.32% Client 3 5,000 4,500 0 0 9,500 % of Prior Month 90.00% 0.00% #DIV/0! % of Current Month 12.00% 0.00% 0.00% Client 4 15,000 15,000 13,000 8,000 51,000 % of Prior Month 100.00% 86.67% 61.54% % of Current Month 40.00% 44.83% 25.72% Client 5 3,500 5,000 7,500 9,000 25,000 % of Prior Month 142.86% 150.00% 120.00% % of Current Month 13.33% 25.86% 28.94% 33,500 37,500 29,000 31,100 131,100 For Client 2 for Feb-08 the % of Prior Month should be 100%. For Client 3 for Apr-08 the % of Prior Month should be 0%. I don't know how to get the new rows to calculate inside the pivot table. I think that Calculated Fields would be used but I can't seem to figure how to do it after reading some books that I have. Any help would be greatly appreciated. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505716
  - 11
    - SUMIF Criteria I'm trying to use the SUMIF function with criteria that value must be >30 and <=60. How would I code that with this function? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505715
  - 12
    - Single Quote use in cell reference I am trying to decifer a spreadsheet prepared by someone who has left the company. They used the following cell reference, which appears to reference an outside spreadsheet without using the full spreadsheet name, ='AR ''06'!G414. What do the two separate items in single quotes do. I can't figure out what 'AR ''06' is? Any thoughts are greatly appreciated. Thank You, Tag: Shading of Multiple Rows in a Pivot Table Tag: 505695
  - 13
    - Sum If Help I need to have a total cell for a large spreadsheet I'm working on (150+lines of data). I need to put in a formula that will add the amount in Column B if the word in the Column A says "Retail". Example: A B Retail 10,950 Storage 6,500 Retail 5,000 Retail 4,000 Storage 3,500 Total Retail Amount Total Storage Amount Relatively new to Excel, so any help would be greatly appreciated!!! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505693
  - 14
    - Formula Halp - If or Lookup I am not sure how to get the results I am looking for, and if it is better to use an if statement or a lookup funtcion (which I have never used before). Data Information: Column "AO" contains one of 5 names Based on looking at these names, I want a formula that puts one of 5 corresponding intials in column BA. Any formula suggestions would be truly appreciated!! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505691
  - 15
    - conditional formatting I am trying to import categorical data into a spreadsheet. I need the categorical data to import as numerical values (i.e. white = 1, black = 2, hispanic = 3, etc.) Is there a way to do this using conditional formatting? If not, please offer a different suggestion. Thanks! Tag: Shading of Multiple Rows in a Pivot Table Tag: 505690
  - 16
    - To count how many are in a certain age group Hi! I'm looking for at forumla to count how many are in a certain age group. I have a list of people and their ages and would like to know how many are in the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on -- LEG Tag: Shading of Multiple Rows in a Pivot Table Tag: 505689
  - 17
    - How do I move numbers with formulas behind to new workbook? I'm working with excel 2003. I received a spread sheet via email. There are several colums adding up to a total. I want to do is take the total column and the vendor name and move them to a new workbook. when I copy and paste, the information will not transfer because of the related formulas. Help Please Tag: Shading of Multiple Rows in a Pivot Table Tag: 505688
  - 18
    - Condiitonal formatting-colored cell I would like a cell to turn yellow if I start a sentence with an *, if there is no *, then no color. How would I phrase this in the conditional formatting option? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505687
  - 19
    - Find next value I am trying to return a value in cell B3 from E5:E40 using the SUMIF formula. In cell B4 I want to return the next value in E5:E40 that meet the same criteria. Right now it is adding them together. Thanks Bobby Tag: Shading of Multiple Rows in a Pivot Table Tag: 505684
  - 20
    - some worksheet columns don't update formula calculations I have a worksheet where my sheet 1 is taking numbers from sheet 2 and 3 and then using those numbers from sheet 2 and 3 to make calculations sum formulas that I've inserted. Some of the columns work fine, when I make a change to a cell 4, column 4 in sheet 2, I notice the numbres change in sheet 1 and reflect the changes I made to the cell in sheet 2, but some other columns don't work in sheet 2. For example when I make a change to cell 4 in column 5, the numbers on sheet 1 don't reflect the change I made. The formula's on sheet 1 are correct and are pointing to sheet 2. The only way the calculation works on sheet 1, is that if I click on sheet 1 where the cell pointing to cell 4 in column 5 for sheet 2 is and then hit enter. Any idea's why that is happening on certain columns but not others? Tag: Shading of Multiple Rows in a Pivot Table Tag: 505682
  - 21
    - help with formula - Hi, Legend: a1 b1 TX 8.25% MA 5% ------------- c1 d1 $100 MA $200 TX $300 EU -------------- How do I obtain a formula, perhaps vlookup, that if, column (D) matches with ledgen column (A), then take value column (c) time the percentage column (B), otherwise, N/A? Thanks Soth Tag: Shading of Multiple Rows in a Pivot Table Tag: 505681
  - 22
    - text for numbers I am using SUMIF for returning number values that meet certain criteria. Now I want to return text, instead of numbers, that meet certain criteria and am having trouble. Also I do not want a zero to return where there is no value. Thanks Bobby Tag: Shading of Multiple Rows in a Pivot Table Tag: 505680
  - 23
    - Accidental Currency Converted Hmm, strange one. I opened a file recently and all my $ changed to DM. As I opened other files, same thing. Our IT department just put SAP's Business Explorer on my desktop and I am wondering (being a German company and the fact that it is coming up at Deutche Marks) that the SAP install reset some setting. Anyway, I checked via the Control Panel, and all my Regional Settings look fine (e.g. US). I can't find (at least in Excel 2007) anywhere that I can convert everything back to $..except manually - and this would go for every spreadsheet I use. Any thoughts? Thanks. v/r PAZ Tag: Shading of Multiple Rows in a Pivot Table Tag: 505679
  - 24
    - Duplicate entries in single column w/o sorting? I am trying to find duplicate entries (text) in a single column without sorting. The column is several hundred rows in length. Can someone help? -- Regards, SColdiron Tag: Shading of Multiple Rows in a Pivot Table Tag: 505673
  - 25
    - vlookup on multiple values I have the following data in 3 columns A B C TOP BULB 1 TOP SCREW 5 TOP LIGHT 1 TOP LAMP 1 TOP PAPER 1 BOTTOM BULB 5 BOTTOM SCREW 4 BOTTOM LIGHT 2 BOTTOM LAMP 8 BOTTOM PAPER 7 I want to be able to first match against the value in column a then find the match in column b once it finds both match then return the result of column 3. Tag: Shading of Multiple Rows in a Pivot Table Tag: 505670

How do you shade multiple total rows in a pivot table on one click?

Re: Shading of Multiple Rows in a Pivot Table by Debra

Debra
Thu May 08 18:24:41 CDT 2008

To format cells, enable selection should be turned on.
To enable selection --
From the Pivot toolbar, choose PivotTable>Select
If it's not already activated, click on Enable Selection

To format a section of a pivot table, e.g. column headings --
Move the pointer to the top of the column field button in the pivot table.
When the black arrow appears, click to select the column headings Format
the selected headings

JanT wrote:
> How do you shade multiple total rows in a pivot table on one click?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Top