Glad it was useful to you, Dave!

Cheers, Wayne! Good idea to use colour formatting of the emojis :-)

Great to hear :-)

Glad it helped! 😊

Thanks so much! And to you 🥰

Thanks so much, Libby! Please share it with your friends :-)

Wow, thanks, Ramandeep!

Thanks so much, Alejandro!

Awesome! Thank you!

Great job!

Glad you like them, Dimitar!

Thanks, Darryl! Glad you like them :-)

Cheers, Chris!

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.

​Agree!

So pleased you liked this video, Zafar! Please share it with your co-workers too :-)

:-) glad you can use it!

Glad it was of interest to you, Clive!

Thanks so much, Nader!

So glad to hear that, Abdul!

Glad to hear that, Venkat!

Thank you so much, George 😊

Glad to hear it!

So pleased you can use it, Ivan!

You’re welcome 😊

You are so welcome!

My pleasure, Antonio!

Thanks, Hans!

Glad you liked it, Maki!

You are so welcome!

So pleased you enjoyed the video, Zubair!

Glad you liked it!

Thank you :-)

Thanks, Arturo!

So glad, Sandeep!

Yes!

Great to hear it was useful!

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.

You need to save the custom format in your default workbook: www.myonlinetraininghub.com/customize-default-excel-workbook

Glad you enjoyed the video :-)

That example is available here: www.myonlinetraininghub.com/excel-custom-number-format-conditions

Спасибо!

Thanks, Shakira!

Me alegro de que te hayan gustado :-)

It's still working for me with more than 8 colours 🤔

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.

So glad, Yulin!

My pleasure, John :-)

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.

Thanks so much, Jules!

Thank you! Cheers!

Yes, you sure can use them in Conditional Formatting too :-)

Hi Toan, That is just a Pivot Chart with Slicers: www.myonlinetraininghub.com/excel-pivot-charts

Thanks so much!

Thanks, Syed. Conditional number formats only allow 3 criteria, so it won't work for your needs, sorry.

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.

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

Yes, good point, Melinda!

:-) thanks!

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.

[Green]❖;[Yellow]❖;[Red]❖

Thank You

Thanks :-)

Obrigado!

Glad you're enjoying my tutorials :-)

Yes madam learn lot thank you