The power of using colours is that it’s easy to instantly understand the current status of your business. Something red? Better make a plan to fix it. Got a couple yellow areas? Ask your manager what she’s doing to address it. Notice a few green items? Congratulate the team!
I really liked Ryan Carson’s recent piece on measuring your key performance indicators with Red, Yellow or Green formatting. You can see his example spreadsheet here if you are interested.
