How to use conditional formatting in custom sections

Lily
Lily
  • Updated

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 create a new custom section.

 

Step 2: Click on this Vector1.png icon located on the right of the custom section heading. 

 

conditional formatting  custom sections.png

 

 

Step 3: From the drop-down menu click on Conditional Formating

 

Select-conditional-formatting-.jpg

 

 

Step 4: Add your condition formatting rules:

Cell-Ref: Alphabet-a.png Enter the cell position you would like to add conditional formatting for e.g. B1, C3, D15, etc. 

Attribute name: Alphabet-b.png Select one of the attributes you would like to highlight. Text-color or Background color.

Attribute value: Alphabet-c__1_.png Enter a color name or code, e.g.- #ff0000 for red shade.

Comparison: Alphabet-d.png Select the comparing rule.

Number to compare: Alphabet-e.png 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. 

 

add-conditional-formatting-rules.jpg 

 

 

Step 6: Enter the values in your table and the cells with the formatted rules will be auto-highlighted. 

 conditional-formatting-rules.jpg

 

 

Learn more about how you can further format your custom section. 

 

Share this

Was this article helpful?

0 out of 0 found this helpful