I've never really dabbled with custom number formats, thanks for this Mynda, you have given me a whole host of new ideas.
@MyOnlineTrainingHub4 жыл бұрын
Glad it was useful to you, Dave!
@RamandeepSingh-dt5ls4 жыл бұрын
Hands down the best channel I found recently. Learning a real deal from the very best. Thanks a ton for your work Mynda.
@MyOnlineTrainingHub4 жыл бұрын
Wow, thanks, Ramandeep!
@JAAP21014 жыл бұрын
More clear, impossible. Amazing class!!
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much, Alejandro!
@aiasaiascon389410 ай бұрын
awesome lesson, Mynda !!! Merry Christmas and a Happy New Year full of health and strength for all of You!!!
@MyOnlineTrainingHub10 ай бұрын
Thanks so much! And to you 🥰
@nsanch01814 жыл бұрын
Great video Mynda. I just starting watching your videos this weekend, and I really enjoy them. Thank you.
@MyOnlineTrainingHub4 жыл бұрын
Awesome! Thank you!
@makisalimhussain23343 жыл бұрын
Thank you Mynda, I tried using emoji shapes without using quotation marks ( " ) [>80]👍;[>70]👌;🤔 and it works
@MyOnlineTrainingHub3 жыл бұрын
Great job!
@wayneedmondson10654 жыл бұрын
Hi Mynda. Great Custom Number Formatting tips. Too bad the native emoji colors are not possible to display. Worth noting that you can still put standard colors on them, as in: [Green][>80]"🙌";[Yellow][>50]"👌";[Red]"👎". Not as good as native, but maybe better than gray scale. Thanks for the video and good learning. Thumbs up!!
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Wayne! Good idea to use colour formatting of the emojis :-)
@dimitargyoshev58964 жыл бұрын
I am very grateful for your lessons presented in a very understandable way. Thank you !
@MyOnlineTrainingHub4 жыл бұрын
Glad you like them, Dimitar!
@zafarrizvi86764 жыл бұрын
Mynda, you post some absolute gems. I am a great follower.
@MyOnlineTrainingHub4 жыл бұрын
So pleased you liked this video, Zafar! Please share it with your co-workers too :-)
@peteradeteacher13804 жыл бұрын
i learned something new too. i only new how to enter symbols through clicking ctrl and writing the unicode but never thought i can make it a format
@MyOnlineTrainingHub4 жыл бұрын
Great to hear :-)
@sherlock274 жыл бұрын
OMG! Never thought it's possible. Thanks Mynda.
@MyOnlineTrainingHub4 жыл бұрын
:-) glad you can use it!
@abdulhaseeb80274 жыл бұрын
Simply loved this tutorial and learnt alot of new things. Thanks Mynda!
@MyOnlineTrainingHub4 жыл бұрын
So glad to hear that, Abdul!
@noorddinn Жыл бұрын
Thank you! A tiny and somewhat hideous detail that worked for me which you mentioned and that nobody else did! So highlighting the shapes and copy them would do the trick, I was copying the cell which was not be copied and pasted in the custom formatting, so thank you again!
@MyOnlineTrainingHub Жыл бұрын
Glad it helped! 😊
@libbyreiser62144 жыл бұрын
Absolutely awesome lesson, Mynda. You are a genius! We appreciate your knowledge share!!
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much, Libby! Please share it with your friends :-)
@clivepetty23384 жыл бұрын
Many thanks, another very powerful feature in excel, I seen other formatting guides used them and does make data more presentable, I like the charting update as this an area which gives me issues with presentation
@MyOnlineTrainingHub4 жыл бұрын
Glad it was of interest to you, Clive!
@tedmcswain4 жыл бұрын
You do a great job and it's most appreciated. You're definitely in your element.
@MyOnlineTrainingHub4 жыл бұрын
Thank you so much, George 😊
@venkatiyer74594 жыл бұрын
Thanks Madam .. it was really useful one and your way of explaining things were too good and in a easy way to understand for person with minimum knowledge of excel ... thanks again
@MyOnlineTrainingHub4 жыл бұрын
Glad to hear that, Venkat!
@darrylmorgan4 жыл бұрын
Hi Mynda!Great Custom Formatting Tips,Emojis Look Great Fun...Thank You :)
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Darryl! Glad you like them :-)
@jamc6664 жыл бұрын
Excellent video as always .... addendum 13:30 .. 3rd parameter is to format zero (0) values
@MyOnlineTrainingHub4 жыл бұрын
Yes, correct :-) and after that is the text format. I cover that in my comprehensive custom number format guide here: www.myonlinetraininghub.com/excel-custom-number-format-guide
@jamc6664 жыл бұрын
@@MyOnlineTrainingHub oh, hi :)... YT channels such as yours are invaluable. Love it. Speaking about formatting... Is there any way to display correctly a negative time value? For example time worked - time due... Let's say someone needs to work 8 hours but only worked 7 there is a -1 hr to catch up. If someone works 9 hrs instead, there's a 1 hr overtime. The simple formula =(worked-due) doesn't seem to work in both cases. Thank you.
@chrism90374 жыл бұрын
Very nice video Mynda!
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Chris!
@nadermounir82283 жыл бұрын
Thank you Mynda this is a great video 📹.
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Nader!
@not1AM4 жыл бұрын
I always learn something new from you... THANKS
@MyOnlineTrainingHub4 жыл бұрын
Glad to hear it!
@Olu_boomie4 жыл бұрын
Thanks so much for sharing Mynda!
@MyOnlineTrainingHub4 жыл бұрын
You are so welcome!
@IvanCortinas_ES4 жыл бұрын
Excellent explanation Mynda. Very useful. I'll put into practice. Thank you very much for sharing.
@MyOnlineTrainingHub4 жыл бұрын
So pleased you can use it, Ivan!
@SyedMuzammilMahasanShahi4 жыл бұрын
Wow. That's amazing. I never knew we could use emoji in this way. Thanks for the share.
@MyOnlineTrainingHub4 жыл бұрын
You’re welcome 😊
@zubairso4 жыл бұрын
Really insightful, thanks Mynda!
@MyOnlineTrainingHub4 жыл бұрын
So pleased you enjoyed the video, Zubair!
@hcandts4 жыл бұрын
Once again, great lesson, Thank you
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Hans!
@DiegoAlzate4 жыл бұрын
Excellent tips thank you☺
@MyOnlineTrainingHub4 жыл бұрын
You are so welcome!
@mshi58267 ай бұрын
In the scaling, could you also apply red font color & bracket for all negative number?
@sandeepreddy34824 жыл бұрын
This session was super informative, great learning today. Thank you
@MyOnlineTrainingHub4 жыл бұрын
So glad, Sandeep!
@EYEmaginary4 жыл бұрын
Have been looking for this! Thanks
@MyOnlineTrainingHub4 жыл бұрын
Great to hear it was useful!
@arturoguzman52304 жыл бұрын
Mynda I love you 😍 the sunglasses emoji is me. I must see all your KZbin videos and of course y put 👍
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Arturo!
@gladiadordoexcel23584 жыл бұрын
I Love youuuuu. Great lesson! I wish I could love my girl as I love Excel.
@MyOnlineTrainingHub4 жыл бұрын
Glad you enjoyed the video :-)
@excel-businessinexcel51814 жыл бұрын
Спасибо! Всегда вас слушаю.
@MyOnlineTrainingHub4 жыл бұрын
Спасибо!
@wolfy13403 жыл бұрын
Thanks a lot you are fantastic. Great job
@MyOnlineTrainingHub3 жыл бұрын
Thank you :-)
@cledisonnascimento98254 жыл бұрын
Sensational video as always, by the way. But how did you manage to customize the format in Excel Online?
@MyOnlineTrainingHub4 жыл бұрын
Thank you! You create the format in Excel on the desktop and then when you open the file in Excel Online it is available to use.
@makisalimhussain23343 жыл бұрын
Awesome Mynda I've given the thumb up and I like to give more, but no way to do it in youtube. 👍👍👍👍👍
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Maki!
@shakiraasfoor75994 жыл бұрын
Well Done Mynda
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Shakira!
@ljudevitgaj48554 жыл бұрын
Muchísimas gracias, me ayudan dandome ideas para mi trabajo.
@MyOnlineTrainingHub4 жыл бұрын
Me alegro de que te hayan gustado :-)
@inxanadu85764 жыл бұрын
Really cool!! Thanks
@MyOnlineTrainingHub4 жыл бұрын
Glad you liked it!
@djs22204 жыл бұрын
amazing training as always! Thank you! Non Excel related question, what keyboard are you using? Looks cool. :)
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Darren. I use a Microsoft Surface keyboard. I wanted something that didn't have noisy keys and all the 'noise free' keyboards I tried were rubbish, but this is similar to a laptop keyboard, which are typically quieter than regular keyboards.
@djs22204 жыл бұрын
@@MyOnlineTrainingHub thanks for the reply I appreciate it. I will check it out. Take care.
@yulinliu8504 жыл бұрын
Very helpful. Thank you!
@MyOnlineTrainingHub4 жыл бұрын
So glad, Yulin!
@nana_dadzie4 жыл бұрын
Amazing stuff. I love it.
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much!
@ZdenekMoravecCZ10 ай бұрын
Does it mean, that the custom format with [] criteria beats the default "positive;negative;zero;text" custom format logic?
@MyOnlineTrainingHub10 ай бұрын
Yes!
@johnborg54194 жыл бұрын
Thanks Mynda :) :)
@MyOnlineTrainingHub4 жыл бұрын
My pleasure, John :-)
@overdraftracing4 жыл бұрын
stupid question I'm sure, but once you've created a custom format, how do you make it available throughout Excel? I built a specific number format I wanted to reuse but I couldn't get it to stick in Excel. Every time I created a new worksheet I had to start building the format from scratch as it wasn't in the custom list anymore... Thanks for any help!
@MyOnlineTrainingHub4 жыл бұрын
You need to save the custom format in your default workbook: www.myonlinetraininghub.com/customize-default-excel-workbook
@antoniodias78583 жыл бұрын
I figuered out it's work with: #,0 \M, where between 0 and "\" I inserted two spaces, many thanks for your support
@MyOnlineTrainingHub3 жыл бұрын
My pleasure, Antonio!
@JPHEILEMAN2 жыл бұрын
Hello. I have a problem with a spreadsheet that contains a very large number of custom cell formats which prevents me from copying a tab from this file to another spreadsheet. I have tried to remove all the custom formats manually but the "too many custom formats" message persists. I have the 2013 version of Excel. Do you know how to fix this? Thanks you for your tips and advices.
@MyOnlineTrainingHub2 жыл бұрын
You'll probably need some VBA to clean the custom formats from the file. If you do a Google search on it, I'm sure you'll find some code.
@bobumlas65624 жыл бұрын
You can get colors with the emojis-- (these aren't the same emojis you used...) [Green][>80]"👌";[Yellow][>50]"❤";[Red]"👎"
@MyOnlineTrainingHub4 жыл бұрын
Cheers, Bob. The flat colours aren't quite as nice as the proper emoji formatting though. Hopefully the desktop Excel app will get the emoji formatting someday.
@bobumlas65624 жыл бұрын
Agree!
@zdzislawkes4 жыл бұрын
You are my Excel Master. I am wondering only one thing. If someone knows the possibilities of custom formatting, the same icons can be used in conditional formatting. The advantage of this approach is that the syntax for these conditions is a bit easier, and you can add more conditions (I heard you can insert 64 conditions ;-). Best regards
@MyOnlineTrainingHub4 жыл бұрын
Yes, you sure can use them in Conditional Formatting too :-)
@ToanNguyen-tk7uf4 жыл бұрын
Hey Mynda, can you show me how to create an interactive graph like the one in the video?
@MyOnlineTrainingHub4 жыл бұрын
Hi Toan, That is just a Pivot Chart with Slicers: www.myonlinetraininghub.com/excel-pivot-charts
@keithmitchell1994 жыл бұрын
Hi Mynda, Thanks this is great. however I cannot open the emoji dialog box with windows key. Using Excel 2016, how do we access it with this version?
@MyOnlineTrainingHub4 жыл бұрын
Hi Keith, you hold down the windows key and press the semicolon key at the same time.
@keithmitchell1994 жыл бұрын
@@MyOnlineTrainingHub Thanks but that does not work on my computer, only inserts a semicolon into the cell. No worries though I'll get by.
@KimzCraftz4 жыл бұрын
@@keithmitchell199 On my pc it is Windows and the period (full stop) key
@manasa56393 жыл бұрын
Hi,How to have Orange /Amber colour (while doing 3 color custom formating - Green,Amber,Red)
@MyOnlineTrainingHub3 жыл бұрын
That example is available here: www.myonlinetraininghub.com/excel-custom-number-format-conditions
@SajjadHSyed4 жыл бұрын
Hi Mynda, This is A W E S O M E. I am testing a bit different use. I am using with #s 12, 4, 6 and 0 to show "Monthly", "Quarterly", "Half Yearly" and "Annual". However, I am successful to achieve three but Excel doesn't allow me to do it for 4 conditions. Any suggestions? Thanks again.
@MyOnlineTrainingHub4 жыл бұрын
Thanks, Syed. Conditional number formats only allow 3 criteria, so it won't work for your needs, sorry.
@HanifTutorial4 жыл бұрын
Good👍👍
@MyOnlineTrainingHub4 жыл бұрын
Thank you! Cheers!
@julessarkissian61474 жыл бұрын
You are awesome
@MyOnlineTrainingHub4 жыл бұрын
Thanks so much, Jules!
@antoniodias78583 жыл бұрын
Hi Mynda. why i can not do that format [>=1000000]$#.0,,"M"; in my excel 365. When I do this the commas appear and the number does not format
@MyOnlineTrainingHub3 жыл бұрын
Hi Antonio, I suspect you are on a European number format where dots are commas and vice versa. Try [>=1000000]$#,0.."M"; and see if that works.
@aleksandr8809 Жыл бұрын
Looks like Excel now accepts only 8 basic colors for custom formats. No other options are possible on my version.
@MyOnlineTrainingHub Жыл бұрын
It's still working for me with more than 8 colours 🤔
@trendingpublic10692 жыл бұрын
Nice
@MyOnlineTrainingHub2 жыл бұрын
Thanks :-)
@MrDhunpagla4 жыл бұрын
It is 👍🙂🙂🙂🙂 absolute W😀W 👍🙏
@MyOnlineTrainingHub4 жыл бұрын
:-) thanks!
@johanverkerk3260 Жыл бұрын
[Green][1][❖];[Red][0][❖];[Yellow][-1][❖] is this possible? or how is it possible?
@MyOnlineTrainingHub Жыл бұрын
[Green]❖;[Yellow]❖;[Red]❖
@johanverkerk3260 Жыл бұрын
Thank You
@domingospereira30414 жыл бұрын
Muito Bom
@MyOnlineTrainingHub4 жыл бұрын
Obrigado!
@melindam27763 жыл бұрын
One thing to keep in mind when colour coding numbers, is that you might have a colour blind colleague. I constantly have to remind not to use red for negative numbers. 😕
@MyOnlineTrainingHub3 жыл бұрын
Yes, good point, Melinda!
@sharathpuni39054 жыл бұрын
I love you madam from Bangalore
@MyOnlineTrainingHub4 жыл бұрын
Glad you're enjoying my tutorials :-)
@sharathpuni39054 жыл бұрын
Yes madam learn lot thank you
@Sharon_McCluskey3 жыл бұрын
Hello how to put numbers or letters on emoji please. Example 🔤🆓️🆒️
@MyOnlineTrainingHub3 жыл бұрын
Not sure, Sharon. I can't make out those emojis, but I'd expect you can't create them yourself, you can only choose from emojis in the standard libraries.