Vorlage:Video-BedingteFormatierungSchriftfarbe-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „center|border|808px <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overf…“) |
Keine Bearbeitungszusammenfassung |
||
| (3 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| 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 | |||
<li> <p align="left"> Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion. | <li> <p align="left"> Click on the "Conditional Formatting" button in the "Design" ribbon. </li> | ||
<li> <p align="left"> Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion. | |||
<br> → A dialog opens where you can specify the behavior of the conditional formatting more precisely. | |||
<li> <p align="left"> Select the "custom format" option in the right-hand selection dialog.</li> | |||
<li> <p align="left"> In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.</li> | <li> <p align="left"> In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.</li> | ||
<li> <p align="left"> Save the Excel document and switch to Word.</li> | <li> <p align="left"> Save the Excel document and switch to Word.</li> | ||
<li> <p align="left"> Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings. </li> | <li> <p align="left"> Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings. </li> | ||
<li> <p align="left"> Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band. The table is updated and the conditional formatting is applied to the table.</li>. | |||
<li> <p align="left"> Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band. | |||
<br> → The table is updated and the conditional formatting is applied to the table.</li>. | |||
</p> | </p> | ||
</center> | </center> | ||
</div> | |||
</div> | </div> | ||
Aktuelle Version vom 1. Dezember 2023, 10:15 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 "Design" ribbon.
-
Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion.
→ A dialog opens where you can specify the behavior of the conditional formatting more precisely. -
Select the "custom format" option in the right-hand selection dialog.
-
In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.
-
Save the Excel document and switch to Word.
-
Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings.
-
Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band.
→ The table is updated and the conditional formatting is applied to the table. .