Google Sheets – Conditional Formatting Duplicate Values Tutorial – Highlight Duplicates

Google Sheets – Conditional Formatting Duplicate Values Tutorial – Highlight Duplicates

Comments(25)

  1. Redha Al-Obaidy says:
    January 1, 2020 at 5:37 am

    it is not working !!!!!!!!

  2. Laleh Youseflavi says:
    January 1, 2020 at 5:37 am

    I am a big fan of your videos, can u pls tell me what can i do if I want to delete the row with the duplicate ? thanks

  3. Jasmine Joy Legaspi says:
    January 1, 2020 at 5:37 am

    You are my savior! Muaaaa

  4. Tanuj Bansal says:
    January 1, 2020 at 5:37 am

    may I know if I can colour different duplicates with different colours?

  5. Nuno Soares says:
    January 1, 2020 at 5:37 am

    thank you for being so kind and helpful.
    two questions, i've tried to match the same repeated argument duplicates with different colours and i can't find a way. The other question in about the cells without value,they will appear, so we need to use..if(NOT(ISBLANK(blá blá bla..)?? or we have an other way?

  6. Jared Ngesa says:
    January 1, 2020 at 5:37 am

    I can't see the whole countif formula string. After I type the range put a comma what else do I put before I put the criterion?

  7. Hubert Ambrois says:
    January 1, 2020 at 5:37 am

    Great videos !
    Thanks a lot
    Why do we need a double minus in this expression?

  8. SAWADEEBET CASINOONLINE says:
    January 1, 2020 at 5:37 am

    very very goodddddddddddd

  9. Datum TI Corp says:
    January 1, 2020 at 5:37 am

    Sir, i've been trying to apply this formula the exact same way you did, and it returns as 'invalid parse'. How can i proceed? :/

  10. Jesse Munson says:
    January 1, 2020 at 5:37 am

    finally, a formula that works

  11. Sehab says:
    January 1, 2020 at 5:37 am

    your explanation is soo good

  12. Morgan says:
    January 1, 2020 at 5:37 am

    Hello guys… did you try to use this formula also to check the data simultaneously on differents tabs?

  13. Ali Saleh says:
    January 1, 2020 at 5:37 am

    Thank you for sharing. You are Awesome and I am learning a lot from your videos . Your explanation is very clear. Keep up the good work.
    What I noticed is that in order to hight the entire row this formula can be put in the conditional formatting, namely: =COUNTIF($A$2:$A$17, $A2)>1. The only difference is that I put $ in front of A2. Please check it out.

  14. ZEN TANGO Oscar Wright says:
    January 1, 2020 at 5:37 am

    Can you help ? I have created an expense income sheet. When an expense is made by credit care, I would like to the sum to subtract from the row which contains the running credit card balance as well as subtract from the row which contains the overall balance.

  15. Muhammad Naeem Ul Haq says:
    January 1, 2020 at 5:37 am

    Please give solution, I want to Highlight Data in Column "B" based on Column "A" (I mean all the words in A1 should be highlighted in B2)

    https://docs.google.com/spreadsheets/d/1KXj7dsIZXhWfL26rSgU8yFY1QGQThY3MPJO23dq9ulY/edit?usp=sharing

  16. alpesh sevak says:
    January 1, 2020 at 5:37 am

    Google sheets me koi particular word ko search karke uaka count chahiye sabhi sheets ka to kese hoga

  17. Роман Бабушкин says:
    January 1, 2020 at 5:37 am

    Why do we need a double minus in this expression?

  18. pennaverdeful says:
    January 1, 2020 at 5:37 am

    Thank you so much, so usefull. I wanna cry now!! T_T

  19. Ed Scholfield says:
    January 1, 2020 at 5:37 am

    Thank you works great, better then Ablebits for our applications

  20. sneakingintocommentsection says:
    January 1, 2020 at 5:37 am

    It was very helpful for my work. Thank you for nice tutorial 🙂

  21. Eugene Soft says:
    January 1, 2020 at 5:37 am

    Thanks a lot! Is that method still working? Can we use COUNTUNIQUE for formating duplicates?

  22. Ivan Liao says:
    January 1, 2020 at 5:37 am

    Thank you so much. Very clearly explained. I'm really impressed. So I work part time at a division of Johns Hopkins University responsible for their online courses. I am involved in quality assurance protocol and I have created several google tools to speed up our protocol. An innovative google sheet + form combo sped up our protocol for online course quality checks by 20%.

    So my point is there's a market for this kind of information and I believe I can link you to various division at Johns Hopkins. Please let me know if you are interested.

  23. Jakob Jordan says:
    January 1, 2020 at 5:37 am

    didn't work for me, until i used semicolon instead of comma between range and criteria…

  24. Aakash Singh says:
    January 1, 2020 at 5:37 am

    awesome bro!…it helped me alot and thanks for sharing.

  25. Mike McCartney says:
    January 1, 2020 at 5:37 am

    Very clever methods and use of array functions. Great video, thanks for sharing.

Post a comment