Showing results for 
Search instead for 
Did you mean: 
TodGrindley Frequent Visitor
Frequent Visitor

Conditional Formatting Limit in Matrix

Hi All,


I was just wondering if there is a maximum limit in using the conditional format in a matrix. I have a matrix table with over 100 rows with 5 different colour formatting conditions and I have lately realised that the rows towards the bottom of the table have remained blank (no color formatting appearing on these rows). To further investigate, I sorted the table from asc to desc and noticed that the rows towards the bottom did not have the conditional formatting applied to them as well. This has me thinking whether there is a maximum limit you can apply to a matrix when it comes to conditional formatting.


Thank you for your responses in advance 

Moderator v-yuezhe-msft

Re: Conditional Formatting Limit in Matrix


There is no such limit. Based on my test, conditional formatting works well when  I have a matrix table with 300 rows with 7 different colour formatting conditions . In your scenario, please check if your color formatting conditions are correct. And you can share sample data of your table here ao that I can test.



Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.