Hi Nick!
I took this to some reporting whiz's and they said that what you're looking to do would essentially be called an "aggregator value in a Text Mode column" which is explained here in this article that is all about Conditional Formatting in Text Mode.
I don't have the exact text mode for you, but I'm hoping this gets you going in the right direction.
Kyna