CommencerCommencez gratuitement

Using conditional formatting on a dashboard

Conditional formatting is another functionality that completed dashboards can contain that allows users to modify the visual display on the dashboard. Here, you will explore the conditional formatting on the same dashboard for the 2016 Olympic Games in Brazil.

There is already a conditional formatting rule set that highlights medal counts greater than or equal to 15. Your task is to adapt this rule so that the dashboard only highlights cells greater than or equal to 25.

Cet exercice fait partie du cours

<cours>Visualisation de données avec Google Sheets</cours>
Voir le cours

Instructions de l’exercice

  • Highlight Gold, Silver, and Bronze figures for the 10 countries and adapt the existing 'Conditional formatting' rule (Value is greater than or equal to 15) to instead highlight values that are greater than or equal to 25.

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice