Especially conditional formatting is almost a magical way to make stunning reports & show off things that are important. I always use conditional formatting & light-weight VBA to enhance my dashboards and analysis. Do you use highlighting techniques in your reports & analysis? Download Example FileĬlick here to download example file & understand how to use this technique. But I know you are awesome enough to figure this out. You can use similar idea to conditionally show messages on your worksheets. Bonus Tip: Use similar technique to enhance user inputs Incorporate this technique in to your dashboard or weekly report. Repeat the steps & this time use the rule =COLUMN(B4) = selCol.Select the rule type as Use a formula… and use a below rules. Select the entire range (B4:I14) and go to conditional formatting > new rule Now that we know which row & column should be highlighted, it is a simple matter of switching on Excel’s highlighting charm – Conditional Formatting. Step 4: Add conditional formatting to highlight selected cell’s row & column So much simpler than using floo network or transmogrifying muggles. Excel would add a blank Worksheet_SelectionChange() sub.Choose Worksheet & Selection Change from the drop-downs.Right click on the sheet name & choose ‘view code’.Outside our highlight range, lets set aside 2 cells (E17 & E18 in this case) for keeping the details of which row & column needs to be highlighted. Lets assume that we are dealing with a range of cells in B4:I14 Step 2: Use 2 cells to capture the selected row & column details This is simple, unless you are AUI (analyzing under influence). Step 1: Identify the area for highlighting So lets learn how to do highlighting today. When looking at a big table of analysis (or data), it would make our life simpler if the selected cell’s column and row are highlighted, so that we can instantly compare and get a sense of things.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |