Vorlage:Video-BedingteFormatierungRichtungen-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 9: | Zeile 9: | ||
<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"> 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> <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 "Directions" submenu from the drop-down menu - and select the desired arrow constellation. | |||
<br> → 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"> 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"> 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> <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> → The table is now updated and the corresponding conditional formatting with is applied to the table.</li> | |||
</p> | </p> | ||
</center> | </center> | ||
</div></div> | </div> | ||
</div> | |||
</div> | </div> | ||
Version vom 7. August 2023, 13:52 Uhr
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 "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. -
Switch to the Word document in which the linked table was included.
-
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".
-
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.