Vorlage:Video-BedingteFormatierungFarbskala-English: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 14: | Zeile 14: | ||
<li> <p align="left"> Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.</li> | <li> <p align="left"> Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.</li> | ||
<li> <p align="left"> Click on the "Conditional Formatting" button in the " | <li> <p align="left"> Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon. </li> | ||
<li> <p align="left"> Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale. | <li> <p align="left"> Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale. | ||
Aktuelle Version vom 1. Dezember 2023, 10:12 Uhr
A detailed explanation of the individual steps
To assign a colored conditional formatting to table cells:
-
Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.
-
Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon.
-
Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
→ The selected cells are now highlighted, depending on the selected formatting scale.