Dynamic Titles

A dashboard title can change according to the selected filter.

Example:

=”Sales Dashboard – “&B2

If B2 = Sirsa, the title becomes:

Sales Dashboard – Sirsa

Another example:

=”Sales Report for “&TEXT(B2,”mmmm yyyy”)

Conditional Formatting

Conditional Formatting helps users quickly identify important values.

Examples

  • Green = Target achieved
  • Red = Target not achieved
  • Data Bars = Sales comparison
  • Color Scales = Performance levels
  • Icons = Up/down performance

Example

Highlight sales above target:

=B2>=50000

Practice

Apply Conditional Formatting to:

  • Sales
  • Profit
  • Performance %
  • Inventory Level
PreviousNext