Conditional Formatting Limit in Matrix

[TodGrindley]

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 

[v-yuezhe-msft]

@TodGrindley,

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.



Regards,
Lydia