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!!
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
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!
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
@@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.
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.
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
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.
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
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!
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.
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.
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.
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. 😕
I've never really dabbled with custom number formats, thanks for this Mynda, you have given me a whole host of new ideas.
Glad it was useful to you, Dave!
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!!
Cheers, Wayne! Good idea to use colour formatting of the emojis :-)
Absolutely awesome lesson, Mynda. You are a genius! We appreciate your knowledge share!!
Thanks so much, Libby! Please share it with your friends :-)
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
Great to hear :-)
More clear, impossible. Amazing class!!
Thanks so much, Alejandro!
Great video Mynda. I just starting watching your videos this weekend, and I really enjoy them. Thank you.
Awesome! Thank you!
Hands down the best channel I found recently. Learning a real deal from the very best. Thanks a ton for your work Mynda.
Wow, thanks, Ramandeep!
I am very grateful for your lessons presented in a very understandable way. Thank you !
Glad you like them, Dimitar!
awesome lesson, Mynda !!! Merry Christmas and a Happy New Year full of health and strength for all of You!!!
Thanks so much! And to you 🥰
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
Glad it was of interest to you, Clive!
Hi Mynda!Great Custom Formatting Tips,Emojis Look Great Fun...Thank You :)
Thanks, Darryl! Glad you like them :-)
Simply loved this tutorial and learnt alot of new things. Thanks Mynda!
So glad to hear that, Abdul!
OMG! Never thought it's possible. Thanks Mynda.
:-) glad you can use it!
I always learn something new from you... THANKS
Glad to hear it!
You do a great job and it's most appreciated. You're definitely in your element.
Thank you so much, George 😊
Thank you Mynda,
I tried using emoji shapes without using quotation marks ( " ) [>80]👍;[>70]👌;🤔 and it works
Great job!
Mynda, you post some absolute gems. I am a great follower.
So pleased you liked this video, Zafar! Please share it with your co-workers too :-)
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!
Glad it helped! 😊
Once again, great lesson, Thank you
Thanks, Hans!
Thank you Mynda this is a great video 📹.
Thanks so much, Nader!
Excellent tips thank you☺
You are so welcome!
Very nice video Mynda!
Cheers, Chris!
Excellent video as always .... addendum 13:30 .. 3rd parameter is to format zero (0) values
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
@@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.
Thanks so much for sharing Mynda!
You are so welcome!
Excellent explanation Mynda. Very useful. I'll put into practice. Thank you very much for sharing.
So pleased you can use it, Ivan!
You can get colors with the emojis-- (these aren't the same emojis you used...) [Green][>80]"👌";[Yellow][>50]"❤";[Red]"👎"
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.
Agree!
Mynda I love you 😍 the sunglasses emoji is me. I must see all your RUclips videos and of course y put 👍
Thanks, Arturo!
Wow. That's amazing. I never knew we could use emoji in this way. Thanks for the share.
You’re welcome 😊
Really insightful, thanks Mynda!
So pleased you enjoyed the video, Zubair!
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
Glad to hear that, Venkat!
Have been looking for this! Thanks
Great to hear it was useful!
This session was super informative, great learning today.
Thank you
So glad, Sandeep!
Really cool!! Thanks
Glad you liked it!
Thanks a lot you are fantastic. Great job
Thank you :-)
Спасибо! Всегда вас слушаю.
Спасибо!
Awesome Mynda
I've given the thumb up and I like to give more, but no way to do it in youtube. 👍👍👍👍👍
Glad you liked it, Maki!
Thanks Mynda :) :)
My pleasure, John :-)
Very helpful. Thank you!
So glad, Yulin!
I Love youuuuu. Great lesson! I wish I could love my girl as I love Excel.
Glad you enjoyed the video :-)
In the scaling, could you also apply red font color & bracket for all negative number?
Well Done Mynda
Thanks, Shakira!
Amazing stuff. I love it.
Thanks so much!
Muchísimas gracias, me ayudan dandome ideas para mi trabajo.
Me alegro de que te hayan gustado :-)
Good👍👍
Thank you! Cheers!
You are awesome
Thanks so much, Jules!
Sensational video as always, by the way. But how did you manage to customize the format in Excel Online?
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.
amazing training as always! Thank you! Non Excel related question, what keyboard are you using? Looks cool. :)
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.
@@MyOnlineTrainingHub thanks for the reply I appreciate it. I will check it out. Take care.
I figuered out it's work with: #,0 \M, where between 0 and "\" I inserted two spaces, many thanks for your support
My pleasure, Antonio!
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
Yes, you sure can use them in Conditional Formatting too :-)
It is 👍🙂🙂🙂🙂 absolute W😀W 👍🙏
:-) thanks!
Does it mean, that the custom format with [] criteria beats the default "positive;negative;zero;text" custom format logic?
Yes!
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!
You need to save the custom format in your default workbook: www.myonlinetraininghub.com/customize-default-excel-workbook
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.
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.
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
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.
Nice
Thanks :-)
Hey Mynda, can you show me how to create an interactive graph like the one in the video?
Hi Toan, That is just a Pivot Chart with Slicers: www.myonlinetraininghub.com/excel-pivot-charts
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.
Thanks, Syed. Conditional number formats only allow 3 criteria, so it won't work for your needs, sorry.
Looks like Excel now accepts only 8 basic colors for custom formats. No other options are possible on my version.
It's still working for me with more than 8 colours 🤔
Hi,How to have Orange /Amber colour (while doing 3 color custom formating - Green,Amber,Red)
That example is available here: www.myonlinetraininghub.com/excel-custom-number-format-conditions
Muito Bom
Obrigado!
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?
Hi Keith, you hold down the windows key and press the semicolon key at the same time.
@@MyOnlineTrainingHub Thanks but that does not work on my computer, only inserts a semicolon into the cell. No worries though I'll get by.
@@keithmitchell199 On my pc it is Windows and the period (full stop) key
I love you madam from Bangalore
Glad you're enjoying my tutorials :-)
Yes madam learn lot thank you
[Green][1][❖];[Red][0][❖];[Yellow][-1][❖]
is this possible?
or how is it possible?
[Green]❖;[Yellow]❖;[Red]❖
Thank You
Hello how to put numbers or letters on emoji please.
Example 🔤🆓️🆒️
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.
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. 😕
Yes, good point, Melinda!