How To Tips & Tricks

Excel: Format cells based on content

As a union steward, one of the many things I do on a regular basis is evaluate key indicators of the company financials. I do this by plotting a few numbers from the accounting reports into Excel, and then run them through some standardised analysis to identify the performance of key indicators. These indicators are evaluated on a five-point scale ranging from “unsatisfactory” to “very good”, and I have set up a total of seven rules using Conditional Formatting to allow me to read the indicators at a glance. Here’s how it’s set up: