![]() ![]() Step 2: Create a New Conditional Format Based on a Formula If you wish to be a bit more conservative with memory management, select a range of cells that you are sure you will never exceed (i.e. This is a good strategy when you are unsure as to the number of records contained in the data. In the above example, that would be Columns “A” through “H” (A:H). Highlight all of the columns containing data. Conditional Formatting is so versatile when painting data based on some criteria, it becomes a perfect tool for achieving just the desired look. You could try to convert the list to a Data Table, but that tool is really meant for straight tables with no intermediate calculations.ĬONDITIONAL FORMATTING TO THE RESCUE!!!!!!!!!!!Ī common request among Excel users is to have the Subtotal lines be filled with a color to help identify them with greater ease. If you have ever used the Subtotals tool to group information you have probably been impressed with its ability to group data by some changing event (like States) and then have those groups aggregated and structured into a collapsible outline.īut the one shortfall when it comes to the Subtotals tool is that there are no built-in artistic styles that can be applied to give the list a bit of pizazz. ![]() Just as there should be a Nobel Prize for the person who put a screwdriver in the end of a power drill, thus inventing the Power Screwdriver, there should be a Nobel Prize for merging the abilities of Conditional Formatting with the Subtotals tool in Excel.
0 Comments
Leave a Reply. |