Duplicate Rows Conditional Formatting

[Nilofer]

Trying to find some documentation on how to Mark Duplicate Rows with Conditional Formatting.

There is ConditionalFormatTemplate in which DuplicateValues option is there, but could not find any write-ins how to use it.

Any advise will be appreciated.

Best Regards,

[Karthikeyan Chandrasekar]

Hi Nilofer, 

Currently we don’t have support to find the duplicate values using conditional format and we are currently working on this . These changes will be included in our main release 2019 Vol 1 which will be available in March 2019.  

However, we can achieve your requirement as a workaround by using conditional format formula. We have prepared a sample for the same which can be downloaded from the following link. 

Sample link : http://www.syncfusion.com/downloads/support/forum/142244/ze/ConditionalFormat-2091402159.zip  

Kindly try this and let us know if this helps. 

Regards, 

Karthikeyan  

[Nilofer]

Thanks Karthikeyan, Will check out. I needed full row to be highlighted.

Best Regards,

[Karthikeyan Chandrasekar]

Hi Nilofer,  

We have modified the sample to highlight entire row based on the duplicate value using conditional format formula in XlsIO. The sample can be downloaded from the following link.  

Sample link : http://www.syncfusion.com/downloads/support/forum/142244/ze/ConditionalFormat243102820.zip 

Kindly try this and let us know if this helps.  

Regards, 

Karthikeyan