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

Aus firesys Hilfe
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
 
(3 dazwischenliegende Versionen von 2 Benutzern werden 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:'''
<ul>
<br><br>
  <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.  
<ol>
  <li> <p align="left"> Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.</li>
 
  <li> <p align="left"> The selected cells are now highlighted, depending on the selected formatting scale.</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 "*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>  


</p>
</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.