We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Duplicate Rows Conditional Formatting

Thread ID:

Created:

Updated:

Platform:

Replies:

142244 Jan 24,2019 06:23 AM UTC Feb 5,2019 04:58 PM UTC WinForms 3
loading
Tags: XlsIO
Nilofer
Asked On January 24, 2019 06:23 AM UTC

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 [Syncfusion]
Replied On January 24, 2019 04:55 PM UTC

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. 


Kindly try this and let us know if this helps. 
Regards, 
Karthikeyan  


Nilofer
Replied On February 4, 2019 08:28 AM UTC

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

Best Regards,

Karthikeyan Chandrasekar [Syncfusion]
Replied On February 5, 2019 04:58 PM UTC

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.  

Kindly try this and let us know if this helps.  

Regards, 
Karthikeyan  


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;