|Conditional Formatting via Slicers, Part Two|
|Written by Rob Collie|
|Thursday, 04 October 2012 19:28|
In the last post on this topic, I discovered what I think is a bug in Excel 2010 conditional formatting, one that prevented me from using the Percentile threshold type with a cell reference.
But the Number type works great, so if I can get the actual [Profit] value for, say, the 80th percentile Model Name into a cell, I can reference that.
And that's precisely what those three cells in the image above contain:Read more...
Latest Author Articles
- Excel 2016: Ten Heartwarming Improvements
- RANKX-apalooza: Within and Across Groups, With Filters, Etc.
- Schrodinger s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
- Repeat Customers in DAX: Three Flavors
- Displaying Top N, Bottom N, and "All Others"