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!!
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
There is a built in duplicate option. Also, here is one of many videos on this topic: ua-cam.com/video/hIz-oZSgn0Q/v-deo.html also: ua-cam.com/video/P1Idd1FZU1I/v-deo.html
@@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...
I love Excel's conditional formatting when it comes to comparing two tables, thanks for this great video 🙏🙏🙏
You are welcome, Stats Guy Ogwal!!!
My fav conditional formatting! Thanks for sharing, Mike!
You are welcome, MVP Malina!!!
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!!
Yes!!!!!!
Great tutorial for people who are in a hurry 🎉. Well done 👍
Boom!The Power Of Conditional Formatting,Awesome Tool...Thank You Mike :)
You are boomingly welcome, darryl!!!!
EXCELlent magic trick! Now I know something additional about excel and only took me ~one minute. Saludos 🇲🇽
Yes! One Minute To Excel Awesomeness : )
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!!
Yes, I use formulas almost all the time, and not use the user interface, which is easier for beginners. I forget like you too : )
hija, after watching the video 5 times, I finally understood :D can I make the empty blocks no fill at all with colour please?
Thanks Mike for the "quick and easy" tips. Enjoy your Thanksgiving.
You are welcome for the new and easy - nice new doggie icon avatar : )
Wow!!! I was stuck on this for quiet some time! Thanking for the tip Mike!
Yes!!! Glad to help, Celia : )
Thanks Mike.
Conditional Formating is awesome.
You are welcome, K D : )
Thank you
You always put up useful videos and many of them helped me a lot at work. Thank you so much! Have a wonderful Thanksgiving.
You are welcome, Tom : )
so much faster than other videos. thanks
Wow Sir thank u so much, in searching this method for long time, thank u so much for this wonderful video 👍
You are welcome, Arman!!!!!
Hi, Sir
Outstanding conditional formatting.
Glad it is outstanding for you : ) : ) : )
Thanks Mike for another great video. Have a nice Saturday :)
You are welcome and I hope your Saturday is great too : )
Please make a video on how to vlookup through multiple sheets,
bassicaly the "table" argument is split through multiple sheets. Thanks.
Liked and Thumbs Up....
Thank You Sirji...
Have Fun!!
Thank you for the support : ) : ) : )
Came to my rescue once again that man!
Excellent video Mike!
Thanks, Chris M : ) : ) : ) : )
Thanks very much
You are welcome!
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
That is a good idea. I am not sure when I can get to it, but I will try : )
@@excelisfun thank you! :)
@@HussainAliNasser It is a great idea : )
Simple but crucial one...
Yes, so TRUE : )
Simple and useful. Thanks Mike.
You are welcome, Teacher Syed MM : ) : ) : ) : )
F4 gets treated like an ugly stepchild when compared to F5 and F8 😂😂 Thanks for showing F4 some love
Go F Keys!!!!!!! Go F4 : ) : ) : ) : )
What if the column A cell has same cell in column z but not in same parallel cell.
How to highlight it then?
This is fun so I dont need to use IF function
Colors are always more enjoyable
:D
Yes! I agree: it IS so much fun : )
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
Ya, I do not know how to do that either... : (
Thanks Mike ; what if i want to apply conditional formating not only for the same cell but for entire column to compare duplicate values
There is a built in duplicate option. Also, here is one of many videos on this topic: ua-cam.com/video/hIz-oZSgn0Q/v-deo.html also: ua-cam.com/video/P1Idd1FZU1I/v-deo.html
Sir, When 6 columns have same values then how to apply conditional format
Thanks for sharing
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.
wow super quick and useful!
Glad it is useful for you, klarawijs!!!
Excellent
thanks a ton sir
Awesome!
Thank you.
Thanks mike :-)
You are welcome, Mohamed!!!
Fun to watch.
Glad it was fun, Teammate : )
Great, I liked it but it was easy and I wished you add bonus tip.
Here is a bonus tip: conditional formatting and formulas allow you to move a face in a sheet www.myspreadsheetlab.com/advanced-conditional-formatting/
I have a duty to make simple videos sometimes because the majority of viewers are brand new to Excel ; )
@@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...
@@maheshvinchhi3785 It is happily my duty : ) : )
@@MySpreadsheetLab Thanks for the tip, Mike and his followers are great. He is my hero.
Thank you
You are welcome!