From the course: Excel: Implementing Balanced Scorecards with KPIs

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Create a conditional formatting rule based on a formula

Create a conditional formatting rule based on a formula

From the course: Excel: Implementing Balanced Scorecards with KPIs

Start my 1-month free trial Buy for my team

Create a conditional formatting rule based on a formula

“

- [Instructor] When you define key performance indicators, KPIs for your business, you need to represent your results in a dashboard. Conditional formatting lets you change the appearance of a cell and its contents based on the cell's value. In this movie I will show you how to implement conditional formatting using icon sets, which use graphics and color to indicate a cell's value. The sample file that I'll work with is 03 04 Conditional. And you can find that in the exercise files folder. In this dashboard I have included a pivot table in columns A and B currently, that displays the sum of order total for the regions for the company Red 30 Tech. In columns C and D, I have regular data. This is not part of the pivot table. So you see in column C I have the target, and for column D I have performance. What I want to do is define a conditional format that will display one icon for a region that met its performance goal.…

Contents