Vorlage:Video-BedingteFormatierungRichtungen-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „center|border|808px <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflo…“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 7: | Zeile 7: | ||
<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> | ||
<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"> Click on the "Conditional Formatting" button in the "Formatting" group in the "Design" menu band. | ||
Version vom 30. Juni 2023, 10:51 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.