Vorlage:Video-BedingteFormatierungFarbskala-English: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 10: | Zeile 10: | ||
<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 "Formatting" group in the "Design" menu band. | <li> <p align="left"> Click on the "Conditional Formatting" button in the "Formatting" group in the "Design" menu band. | ||
<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. | ||
<br> → The selected cells are now highlighted, depending on the selected formatting scale.</li> | |||
</p> | </p> | ||
Version vom 7. August 2023, 13:50 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 "Formatting" group in the "Design" menu band.
-
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.