Vorlage:Video-BedingteFormatierungSchriftfarbe-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt) | |||
| Zeile 10: | Zeile 10: | ||
<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"> 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. | <li> <p align="left"> Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion. | ||
| Zeile 27: | Zeile 27: | ||
</p> | </p> | ||
</center> | </center> | ||
</div> | </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. .