Vorlage:Video-BedingteFormatierungFarbskala-English: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „center|border|808px <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow…“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 7: | Zeile 7: | ||
<p align="left">'''To assign a colored conditional formatting to table cells:'''<br><br> | <p align="left">'''To assign a colored conditional formatting to table cells:'''<br><br> | ||
< | <ol> | ||
<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. | ||
Version vom 30. Juni 2023, 10: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.