Excel Formatting Tip 2 - Highlight Unique or Duplicate Values with Conditional Formatting in Excel

Thank you very helpful.

If I understand correctly, you just need to select the columns separately and then apply the conditional formatting.

thank you so much

Thank you! This is great!!! And you're teaching method is very clear and easy to listen too.

Thankyou vvvv much for showing this option.

Thank-you. Just what I was looking for.

I love you way of teaching, it is awesome

Thanking You

Thank you sir

i apply conditional formatting "Format only unique and duplicate values " This rule apply in one cell .when i copy that cell and paste that rule not working .

Thanks

Thank u

awesome

Man, I end up with your instructional video again! Great job keeping the instruction short but very clear!

my quation is , I have write 30 list where I enter 10 name in each list and total name which I have written in 30 list is 22 name . so how to find dublicate list in 30 list if one name is differ from list then that list unique list give the Solution

One of the longest way

HELPFUL

Great info. Thanks

Please tell me how to change color of active row and column header as your case it is yellow.

I tried it but it doesn’t work . Can I only do a column? I want all the cells to be checked for duplicate and not remove but highlight them. Right now when I do this ALL VALUES get highlighted. Not at all what I created this table for

I filtered only certain criteria . Three rows became filtered. Now in filtered results I need duplicates to become highlighted. But ALL CELLS become highlighted instead because it’s searching in the whole table instead of only in filtered results

Thanks for these videos

Great!! Very helpful

Excellent!! I'm looking forward to more watching more of your video's.

thank you

Thank you!
This is great.

Cool, Simple but very-very useful.... it works. Thank you!

Tysmmmm

Great information thank you!

Superb