Vorlage:Video-BedingteFormatierungSchriftfarbe-English

A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

2. Click on the "Conditional Formatting" button in the "Formatting" group in the "Design" menu band.

3. Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion.

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

5. In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.

6. Save the Excel document and switch to Word.

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

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

.