KPI's in PowerPivot V2

On Tuesday, in my intro to David Hager's post, I promised to circle back "later today" and add some follow-on thoughts. Well, ONE of those words ended up being truthful

But I'm back today! Let's not dwell on the past shall we?

In David's post, he ended up with a "TestStatus" column set to Pass/Fail/Warning depending on a) what the test value reported and b) the specific acceptable ranges established for that particular kind of test.

He was then able to use that as a slicer. But what about conditional formatting? His original example, a regular (non-pivot) table, DID include conditional formatting.