Vorlage:Video-BedingteFormatierungSchriftfarbe-English

A detailed explanation of the individual steps

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 "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.

.