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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
Zeile 13: Zeile 13:
<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>
<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.  
<li> <p align="left"> Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.  

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.