Vorlage:Video-BedingteFormatierungRichtungen-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 "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.