Vorlage:Video-BedingteFormatierungFarbskala-English: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 2: | Zeile 2: | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto"> | <center> | ||
<div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | <div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto"> | ||
<div class="mw-collapsible-content"> | <div style="font-weight:bolder;line-height:1.8;">A detailed explanation of the individual steps</div> | ||
<div class="mw-collapsible-content"> | |||
<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> | <ol> | ||
</p> | <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> | |||
<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> | |||
</center> | </center> | ||
</div> | |||
</div> | </div> | ||
Version vom 8. August 2023, 09:04 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.