The Premium Layout in Excel

Conditional formatting

Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word.

The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables.

Video: Application of a colour scale

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 "*Premium Layout" ribbon.

3. Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
   → The selected cells are now highlighted, depending on the selected formatting scale.

Video: Display of arrow symbols

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

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

4. Switch to the Word document in which the linked table was included.

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

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

Video: The use of conditional formatting with font adaptations

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

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

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

.