Conditionally Format When Two Columns have Same Value. Excel Magic Trick 1704.

[@MalinaC]

My fav conditional formatting! Thanks for sharing, Mike!

[@excelisfun]

You are welcome, MVP Malina!!!

[@ogwalfrancis]

I love Excel's conditional formatting when it comes to comparing two tables, thanks for this great video 🙏🙏🙏

[@excelisfun]

You are welcome, Stats Guy Ogwal!!!

[@darrylmorgan]

Boom!The Power Of Conditional Formatting,Awesome Tool...Thank You Mike :)

[@excelisfun]

You are boomingly welcome, darryl!!!!

[@anthonyverdin6743]

Great video Mike, I live in the south so when you said “Rig” I knew exactly what you was referring to because I used to work in the oil industry!!

[@excelisfun]

Yes!!!!!!

[@kennethultimate02]

Great tutorial for people who are in a hurry 🎉. Well done 👍

[@raitup00]

EXCELlent magic trick! Now I know something additional about excel and only took me ~one minute. Saludos 🇲🇽

[@excelisfun]

Yes! One Minute To Excel Awesomeness : )

[@wayneedmondson1065]

Hi Mike. Great one! Thanks for the reminder of the options in the drop down. I always seem to default to building my own rule, as in: CF >> New Rule >> Use a formula >> =A2=Z2. Need to remember to use the built-in options when available. Good tip :)) Thumbs up!!

[@excelisfun]

Yes, I use formulas almost all the time, and not use the user interface, which is easier for beginners. I forget like you too : )

[@mattschoular8844]

Thanks Mike for the "quick and easy" tips. Enjoy your Thanksgiving.

[@excelisfun]

You are welcome for the new and easy - nice new doggie icon avatar : )

[@celia5132]

Wow!!! I was stuck on this for quiet some time! Thanking for the tip Mike!

[@excelisfun]

Yes!!! Glad to help, Celia : )

[@shantanudeshmukh7021]

Thank you

[@sasavienne]

Thanks Mike. Conditional Formating is awesome.

[@excelisfun]

You are welcome, K D : )

[@tomjun8945]

You always put up useful videos and many of them helped me a lot at work. Thank you so much! Have a wonderful Thanksgiving.

[@excelisfun]

You are welcome, Tom : )

[@Zandor434]

so much faster than other videos. thanks

[@nimrodzik1]

Thanks Mike for another great video. Have a nice Saturday :)

[@excelisfun]

You are welcome and I hope your Saturday is great too : )

[@garethwoodall577]

Came to my rescue once again that man!

[@paultjihitja3046]

Thanks very much

[@excelisfun]

You are welcome!

[@chrism9037]

Excellent video Mike!

[@excelisfun]

Thanks, Chris M : ) : ) : ) : )

[@ArmanKhan-iq3ji]

Wow Sir thank u so much, in searching this method for long time, thank u so much for this wonderful video 👍

[@excelisfun]

You are welcome, Arman!!!!!

[@mitchrunner5439]

hija, after watching the video 5 times, I finally understood :D can I make the empty blocks no fill at all with colour please?

[@abhishek7308]

Hi, Sir Outstanding conditional formatting.

[@excelisfun]

Glad it is outstanding for you : ) : ) : )

[@SyedMuzammilMahasanShahi]

Simple and useful. Thanks Mike.

[@excelisfun]

You are welcome, Teacher Syed MM : ) : ) : ) : )

[@maheshvinchhi3785]

Liked and Thumbs Up.... Thank You Sirji... Have Fun!!

[@excelisfun]

Thank you for the support : ) : ) : )

[@srulyfasten1014]

Please make a video on how to vlookup through multiple sheets, bassicaly the "table" argument is split through multiple sheets. Thanks.

[@Faisal63045]

Thanks Mike ; what if i want to apply conditional formating not only for the same cell but for entire column to compare duplicate values

[@excelisfun]

There is a built in duplicate option. Also, here is one of many videos on this topic: kzbin.info/www/bejne/nnrdXqKQiMyhZrM also: kzbin.info/www/bejne/hmKslZdne7-IZ6s

[@canirmalchoudhary8173]

Simple but crucial one...

[@excelisfun]

Yes, so TRUE : )

[@san_rawat]

What if the column A cell has same cell in column z but not in same parallel cell. How to highlight it then?

[@ahmedzrena6905]

Thanks for sharing

[@greggowaffles]

F4 gets treated like an ugly stepchild when compared to F5 and F8 😂😂 Thanks for showing F4 some love

[@excelisfun]

Go F Keys!!!!!!! Go F4 : ) : ) : ) : )

[@ArmanKhan-iq3ji]

Sir please help me I need a condition if I select yes vlookup function will work if No it will blank it's possible pls tell me Sir.

[@riteshthool1607]

Sir, When 6 columns have same values then how to apply conditional format

[@gopalkumarshell1770]

Thank you.

[@satishsantani1927]

thanks a ton sir

[@HussainAliNasser]

Hey Mike, Can you please do a video (more like a PSA) about the difference between MOD (Excel) and Number.Mod (PowerQuery)? The latter doesn't handle negative numbers like Excel. I learnt about the difference the hard way but might be fruitful for your audience. PS. Excellent video as always

[@excelisfun]

That is a good idea. I am not sure when I can get to it, but I will try : )

[@HussainAliNasser]

@@excelisfun thank you! :)

[@excelisfun]

@@HussainAliNasser It is a great idea : )

[@glad1ator71]

Awesome!

[@klarawijs]

wow super quick and useful!

[@excelisfun]

Glad it is useful for you, klarawijs!!!

[@vrchouhan6166]

Excellent

[@mohamedchakroun4973]

Thanks mike :-)

[@excelisfun]

You are welcome, Mohamed!!!

[@flyer53act]

This is fun so I dont need to use IF function Colors are always more enjoyable :D

[@excelisfun]

Yes! I agree: it IS so much fun : )

[@simfinso858]

Fun to watch.

[@excelisfun]

Glad it was fun, Teammate : )

[@KathleenDougherty-v9r]

how about not equal to??

[@michdax7627]

I like the conditional formatting but the only thing you can't format is alignment I'd like to be able to conditionally Align a cell

[@excelisfun]

Ya, I do not know how to do that either... : (

[@Softwaretrain]

Great, I liked it but it was easy and I wished you add bonus tip.

[@MySpreadsheetLab]

Here is a bonus tip: conditional formatting and formulas allow you to move a face in a sheet www.myspreadsheetlab.com/advanced-conditional-formatting/

[@excelisfun]

I have a duty to make simple videos sometimes because the majority of viewers are brand new to Excel ; )

[@maheshvinchhi3785]

@@excelisfun More Respect felt knowing that you still considering this amazing work and sharing the magic tricks with us as your DUTIES... THANK YOU Sir for all this...

[@excelisfun]

@@maheshvinchhi3785 It is happily my duty : ) : )

[@Softwaretrain]

@@MySpreadsheetLab Thanks for the tip, Mike and his followers are great. He is my hero.

[@TalmadgesArcade]

Thank you

[@excelisfun]

You are welcome!