Only 3 formatting rules from excel template will be used when run the BI report

Summary:

In BI Excel template, we define 5 formatting rules

When we run the BI report, we can see only 3 rules are using.

Is anyone know how to resolve it or it is a bug or limitation for BI publisher

Content (please ensure you mask any confidential information):

N/A

Version (include the version you are using, if applicable):

25C

Code Snippet (add any code snippets that support your topic, if applicable):