This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi All,
I have an Excel sheet with some Duplicate values and some triple duplicate values. I want to highlight duplicate values in different color and triple duplicate values in different color. How i can do that?
I am able to highlight all duplicate value but not able to highlight triple duplicate with different color.
images is attached for reference blue color is repeat three times, yellow color is repeat two times. what i want is whichever value repeat more than 2 times should be highlight with different color.
thanks
Aziz
Hi @Aziz Husain ,
I am just writing to see if you have obtained the opportunity to test the solution. If anything is unclear with the previous information I've provided to you, please don't hesitate to let me know. I am glad to be of assistance.
Hi @Aziz Husain ,
I created a sample about your problem, and you can try these formulas with conditional formatting:
Duplicate :
=COUNTIF($A$3:$H$12,A3)=2
Trpl Duplicate:
=COUNTIF($A$3:$H$12,A3)=3
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Aziz Husain ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.