Vorlage:Video-BedingteFormatierungSchriftfarbe-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 9: | Zeile 9: | ||
<ol> | <ol> | ||
<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 in the "Formatting" group in the "Design" menu band. | |||
<li> <p align="left"> Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion. | <li> <p align="left"> Click on the "Conditional Formatting" button in the "Formatting" group in the "Design" menu band. </li> | ||
<li> <p align="left"> Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion. | |||
<br> → A dialog opens where you can specify the behavior of the conditional formatting more precisely. | |||
<li> <p align="left"> Select the "custom format" option in the right-hand selection dialog.</li> | |||
<li> <p align="left"> In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.</li> | <li> <p align="left"> In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.</li> | ||
<li> <p align="left"> Save the Excel document and switch to Word.</li> | <li> <p align="left"> Save the Excel document and switch to Word.</li> | ||
<li> <p align="left"> 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. </li> | <li> <p align="left"> 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. </li> | ||
<li> <p align="left"> 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.</li>. | |||
<li> <p align="left"> Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band. | |||
<br> → The table is updated and the conditional formatting is applied to the table.</li>. | |||
</p> | </p> | ||
</center> | </center> | ||
</div></div> | </div> | ||
</div> | |||
</div> | </div> | ||
Version vom 7. August 2023, 13:56 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 "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. .