Vorlage:Video-BedingteFormatierungFarbskala-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt)
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>
  <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"> Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
<br> &rarr; The selected cells are now highlighted, depending on the selected formatting scale.</li>


</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 "*Premium Layout" ribbon. </li>
<li> <p align="left"> Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
<br> &rarr; The selected cells are now highlighted, depending on the selected formatting scale.</li>  
 
</center>  
</center>  
</div></div>
</div>
</div>
</div>

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:

  1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

  2. Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon.

  3. 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.