Conditional Formatting Issue

Hi,

I have to assign conditional formatting to some rows and columns.

I can able to do that. but the problem is when I am opening the excel sheet, for each cell I am getting Duplicated Rules for 4 times. I mean the same Rule is coming mutiple times.

I have attached the sample code and sheet and screen shot.

Please check and suggest, why it is happening.

Is my code is incorrect.

Thanks,

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have looked into your issue and it seems, there is some logical error in your code. You are adding conditional formatting again when they are already added. Please recheck your for loops and if conditions.

We have also attached the output xlsx file generated with your code for reference.