Vorlage:Video-BedingteFormatierungRichtungen-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; overflo…“)
 
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.
  <li> <p align="left"> Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.</li>
  <li> <p align="left"> The selected cells are now provided with colored arrows, depending on the selected formatting direction.</li>
  <li> <p align="left"> Switch to the Word document in which the linked table was included.</li>
  <li> <p align="left"> Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".</li>
  <li> <p align="left"> Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".</li>
  <li> <p align="left"> The table is now updated and the corresponding conditional formatting with is applied to the table.</li>  


</p>
<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 "Design" ribbon.</li>
 
<li> <p align="left"> Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.
<br> &rarr; The selected cells are now provided with colored arrows, depending on the selected formatting direction.</li>
<li> <p align="left"> Switch to the Word document in which the linked table was included.</li>
 
<li> <p align="left"> Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".</li>
 
<li> <p align="left"> Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".
<br> &rarr;  The table is now updated and the corresponding conditional formatting with is applied to the table.</li>  
</center>  
</center>  
</div></div>
</div>
</div>
</div>

Aktuelle Version vom 1. Dezember 2023, 10:14 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 "Design" ribbon.

  3. Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.
    → The selected cells are now provided with colored arrows, depending on the selected formatting direction.

  4. Switch to the Word document in which the linked table was included.

  5. Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".

  6. Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".
    → The table is now updated and the corresponding conditional formatting with is applied to the table.