After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning.
Each Test Has a Different “Pass Range” and “Safe Range” –
David Hager’s Technique Translates This Table Quickly into CF Rules
I think this technique can be extended to basically anything: an acceptable sales growth figure for Store A may be different than that for Store B (or Product A vs. Product B, etc.)
His post also got me thinking about the new “KPI” feature in PowerPivot V2, so I will return later today with a brief follow-on post.