Conditional formatting allows you to automatically apply formatting rules for your custom sections. You can apply these rules to format the data color or background color. It makes it easier to highlight cells and highlight values that are out of tolerance value.
In this article, you will learn how to use conditional formatting in your custom sections:
Step 1: Go to the existing custom section in which you would like to add conditional formatting or add a new custom section.
Step 2: Click on this icon located on the right of the custom section heading.
Step 3: From the drop-down menu click on Conditional Formating.
Step 4: Add your condition formatting rules:
Cell-Ref: Enter the cell position you would like to add conditional formatting for e.g. B1, C3, D15, etc.
Attribute name: Select one of the attributes you would like to highlight. Text-color or Background color.
Attribute value: Enter a color name or code, e.g.- #ff0000 for red shade.
Comparison: Select the comparing rule.
Number to compare: Enter the number with which you would like to compare your cell as per the comparison rule.
Step 5: Click on Add to add your rule.
Step 6: Enter the values in your table and the cells with the formatted rules will be auto-highlighted.
Learn more about how you can further format your custom section.