Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572

In this video learn how to add Excel Conditional Formatting to a Row, a Column and the Interesting Value using three logical formulas, Mixed Cell References and the AND Logical Function.

Reference Videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567
Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568
Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570
Excel’s Most Silly Formula Ever Using INDEX or INDIRECT? Excel Magic Trick 1571

[nkenyirene]

I use to think of excel as a misery but it has been simplified to fun by you Mike. I can't say thank you enough.

[sasavienne]

You fulfilled your promise and published this video. Thanks a lot Mike. I have tried to achieve this task yesterday and I got it done but it took me some time. I was delighted that it worked out.

[LongTimeTTFan]

Thanks, Mike. This conditional formatting makes it very easy for the users to visually check the search result. Super helpful. Thanks again.

[jirikubecka]

Wow, the fact that you added a homework for us to practice is so great, that's just what I needed! I was planning to do some revision test after the third episode myself and you just made it a lot easier! Thank you so so much for your videos, they made Excel really fun to me. I'll have so many new opportunities in my work life thanks to you! Just once again, thank you very much :)

[DougHExcel]

Another great example for using conditional formatting...thanks Mike!

[jaleahmad]

I love very much what you have been doing with Excel and sharing it with us..

[robertlohman]

Crystal clear as usual Mike. Another great video.

[mirrrvelll]

Simply amazing and simple to use. Great job man, like all of your videos actually.

[mdtaylor]

This came at the perfect time and I was struggling to do this last night. Now it's working thanks to you 👍🏼

[ca.lakshminarayanreddyjamb]

I don't have words to express gratitude for so much knowledge transfer everyday. You guys are rocking

[success]

Useful information for highlights Particular. Thanks.

[garethwoodall]

Excellent just what I needed. Thank you once again Mike!

[amardeepx]

Your vedio really help me.to learn excel

[DIGITAL_COOKING]

Very nice trick, and very helpful!
You see I'm totally right when I said that excelisfun is the right place to learn excel, and not just that but how to have the fun with it 🙂👍

[jaleahmad]

Astoundingly impressive video, million of thanks Mike.

[vida]

Thanks for the fun with conditional formatting

[chrism]

Mike, this is awesome, and super-useful. Conditional formatting can sometimes be a little tricky, but you really explained it well. Nice job!

[msantosh]

Thankx Mike for adding new videos...excelisfun vid mike👍

[MalinaC]

Awesome! Thanks for conditional formatting fun!!!

[briandemidoff]

Thank you Mike! I have now included this in my spreadsheet and looks fantastic!