Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color

In this video see how to color a row with conditional formatting using the COUNTIFS function, an Expandable Range and a Comparative Operator to convert formula to a Logical Formula. See how to use the Conditional Formatting Dialog Box with a Logical Formula. Also see how to use Conditional Formatting on an Excel Table, so new rows are formatted when new records are added..

[mattschoular]

Thanks Mike and Melina. This peer environment is a fantastic way for all viewers to share and learn.

[DougHExcel]

Wonderful example of condition formatting and COUNTIFS!

[SyedMuzammilMahasanShahi]

Thanks Mike for sharing such a wonderful video

[gloriouz]

Thank you so much! You really do a great job teaching and I love all your videos. Making my job that much easier every day (:

[MalinaC]

OMG! What an honor! You made a film about the case we were discussing - absolutely brilliant! :) I still think your solution is better :)

[chrism]

EXCEL-lent Mike. Another awesome video

[Dhananjay]

Beautiful and enjoying video on how to highlight just the second instance of duplicate values with multiple criteria. Keep up the good work Mike! And waiting for a dueling excel podcast between yourself and Malina C. That would be awesome. What do you think?

[jegane]

Hi! Can we do conditional formatting based on cell color?

[ismailismaili]

it was really fun thank you so much Mr. Mike

[mohamedchakroun]

Thanks for the cond formatting... looking forward to the excel hash :-)

[ahmadabubader]

Great video as usual. How we can give each duplicate group different color? e.g. red color for first duplicate group and green color for 2nd duplicate group

[PaKumarSistla]

Excellent...Its crystal clear explanation...Thank you Mike

[thres]

Hi Mike, thanks for your video. Is there formula that you can apply to include the first row as you can see nothing happend to row 6, thanks

[Softwaretrain]

Hi Mike.
Thanks for your awesome training. I have an idea for setting tatal row for every page. I will happy if you let me to explain it and you creat its training with your enjoyable speech.
Thanks alot. I wish someday you tell my name in your training videos.

[MohamedAlyCLAY]

i love magic tricks :)
about mailna i cant understand this language

[Sublime-zxft]

I was thrown off a bit on why you would paste the formula into the third column given that it has nothing to do with the criteria. But I'm assuming it is so that the cells in that column can get the highlighted formating as well.

[DaveH]

Excellent Mike, who was the other YouTuber you mentioned we should look out for?