Conditional formatting in Outlook tables

This tutorial demonstrates how to implement conditional formatting in Outlook tables, dynamically changing cell text and background colors based on dropdown selections. We'll use a dataset to link discount percentages to specific color codes.

Preparation:

Before starting, ensure you're familiar with creating Outlook tables and using datasets to create dropdown lists (if not, refer to previous tutorials). A dataset, "Dataset with discounts," is created, linking discount percentages to their corresponding hex color codes:

Discount	Color Code
10%	#70AD47
15%	#475496
20%	#FF0000
25%	#2E75B5

A WhatToEnter macro is linked to this dataset, allowing for dropdown selection.

Changing Text Color:

A sample table is used:

Sample Header 1	Sample Header 2	Sample Header 3
[The discount rate should be entered here]

The WhatToEnter macro is inserted into the first cell:

~%WhatToEnter[{dataset:'Dataset with discounts',column:'Discount',title:'Select discount'}] discount

To color the text, the HTML is modified. The relevant section within the HTML is updated to include a <span></span> tag with inline styling:

<span style="color:~%WhatToEnter[{dataset:'Dataset with discounts',column:'Color code',title:'Select discount'}];">~%WhatToEnter[{dataset:'Dataset with discounts',column:'Discount',title:'Select discount'}] discount</span>

This dynamically applies the color code from the dataset to the discount text.

Highlighting a Cell:

To highlight the entire cell's background, the HTML table cell (<td>) is modified. Instead of styling the text, the <code>data-set-style attribute is used:

<td data-set-style="background-color:~%WhatToEnter[{dataset:'Dataset with discounts',column:'Color code',title:'Select discount'}];">~%WhatToEnter[{dataset:'Dataset with discounts',column:'Discount',title:'Select discount'}] discount</td>

This sets the cell's background color based on the selected discount.

Highlighting an Entire Row:

To color the entire row, the <tr> tag is modified similarly, using <code>data-set-style to apply the background color to the entire row:

<tr data-set-style="background-color:~%WhatToEnter[{dataset:'Dataset with discounts',column:'Color code',title:'Select discount'}];">
<td>...</td>
<td>...</td>
<td>...</td>
</tr>

Conclusion:

By strategically modifying the HTML of your Outlook email template, you can effectively implement conditional formatting to dynamically change text and background colors within your tables based on user selections from a dropdown list. Remember to adapt the WhatToEnter macro and color code references to match your specific dataset and desired formatting. The complete HTML code for each example is shown above, allowing you to easily replicate these techniques.

The above is the detailed content of Conditional formatting in Outlook tables. For more information, please follow other related articles on the PHP Chinese website!