![]() ![]() You can format the slicer as appropriate, Resize and Rename it if required You will now have a Slicer linked to the Styles table Select any cell in the Style Table and goto the Insert, Slicer menuĪn Insert Slicers dialog pops up, Select Style This will extract the Maximum value from the Table when the non-selected rows are hidden. In a spare cell H2: add a formula like: =SUBTOTAL(4,Style) I have used four namely: Boss, Blue, Black & White and Funky.Īdd an Id next to each from 1 to x in this case 4 as there are 4 entriesĬonvert the Table to a Table by selecting the area E2:F6 Note: The area above includes the header row, Row 8, but you can actually apply different CF’s to hat independently of the data area if you require Make a list of Style Names Of course using Conditional Formats you can highlight cells based on criteria, so why not extend that to the Whole Report Styling?ĭownload the Sample File (Excel 2013 & 2016 + only): Download Sample File Firstly Identify your Report Area No, Neither had I until recently when somebody asked me for just that: Boss Style Have you ever wondered about applying different Spreadsheet Formats to reports which may be send to different people and so the styling may be different for each recipient? The Boss may get a Formal report where the Art department may get a Funky version of the same data?
0 Comments
Leave a Reply. |