Hi Leila for some reason I am not able to download this file. I got the email but when I click on download I am unable to get the file. I tried using two different emails. Can you help please? Thank you
I wanted to extend my gratitude for the excellent job you did in the video on "Four SMART Ways to Use Custom Formatting Instead of Conditional Formatting in Excel." Your explanation was clear and insightful, and it truly made a difference. You are an Excel evangelist, and your passion for teaching shines through!
I can’t believe I’m sitting here at home on my own time watching a video about Excel that makes me excited to get to work and see what I can do with Custom Formatting - thank you for a clear explanation, I had never really investigated the power of this tool in the past and can’t wait to see what I can do with it!
THANK YOU for being the person to finally De-Mystify the Custom Format options in Excel. For years I have been a little intimidated by how this actually works, but YOU explained it perfectly and in a very useful & time efficient manner. Great job!
Wow. I've been curious about custom formatting for a while, AND I've recently been banging my way through conditional formatting. You've literally just saved me hours of work, and opened up a whole new function of Excel that I didn't know existed!
A short cut for getting the up triangle and down triangle is, for UP - ALT+30 (on numeric keypad), for down ALT+31 (on numeric keypad). This is quicker and easier to remember than inserting symbols
Remember she was teaching syntax, so in this example and ease of understanding without it becoming to overwhelmingly or confusing it was better to use insert symbols. However after the meaning concept was achieve using keyboards would be ideal 🎉
My respected virtual teacher! The logic of custom formatting always remained a mystery for me, but this video revealed this secret now. Thank you so much. May you live long on youtube to share knowledge for spreadsheet lovers.
wow -- very nice. i had viewed ~8 vids, avoiding this one with a 'pretty face. turns out, u provided the best content, rhythm in explaining the content, and u explain both, basic and complex processes within the lesson. then i explored the library of great content and viewed your story -- triple wow. great job Leila -- thank you.
أختي الغالية ليلى، شكرا بحجم السماء. بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-. شكرا مره ثانيه وبارك الله فيك. Keep up the good work
I had taught Excel for years, and knew about the power of custom formatting; but I had only taught it as useful for adding text to numbers, such as "sf" for square foot or "/mth" for per month. I was honestly not thinking I would get a much of a lesson with this video, BUT. I feel like I've been driving my Ferrari custom formatting without every getting out of first gear....I've just enjoyed a thrilling joy-ride with someone who knows how to take that Ferrari and run it thru the gears. Thanks!
I wanted to thank you and mention for other viewers that I immediately discovered this also works well with emoji. Win+. (period) brings up the emoji keyboard. Because sometimes a facepalm is the correct symbol.
Thank you Alberto for your comment! I'm very glad you find the content useful. I also learn a lot from the Excel online community here so everyone wins : )
Oh my word. Why am I so late here. Leila I'm a big fan of yours. The way you present the videos is excellent. You made me believe that I can learn more. I never thought I will learn excel more deeply. But now I guess I can do it.
Thank you! I've been using Excel since first version and use format cell but used conditional formatting because I never took the time to learn custom format. This just saved performance of a large file I'm working on with lots of formatting.
You have explained so well Leila! Thank you so much! My excel skill is quite basic and I will continue to watch all the videos that you made and learned them all! Looking forward to seeing more videos from you! You are such a great teacher.
I aplode you for your work, you are very dedicated, and your content has been very useful for me, and for many other people I'm sure. Thank you a lot ❤️❤️❤️❤️
🤯🤯🤯 Woooow! I've always wondered what those codes meant. And this is super cool! Super easy to understand. Thanks thanks! It's only last week I've found your channel. And I've been binging since! I've also recommended it to my colleagues 🥰
Nicely presented Leila, thank you! I am now able to replace Conditional formatting with Custom formatting, so now my monster workbook looks and performs so much better!
Can you make whole cells a specific colour using this approach? Or do you have to use symbols? Given the performance boost, I want to start using custom formatting where I can - eradicating the need to use conditional formatting.
This is so a pleasure to learn from you: first you find topic that is real painful, and with a nice voice, nice pace, and great pedagogy you walk us through. Thank you very much for this gift. This is typically something we need in a hurry and don’t know how and why ;-)
wow!~ so simple yet powerful formatting. Really learnt from you. Thanks. And I must tell you that your voice is so sweet and clear, so comfortable to listen to. Thank you again👍
Genuinely interesting video. I had never realised you could use custom formatting in such a way. You also delivered the information in such a clear and precise manner that it was simple to follow and understand. I haven’t tried this out yet but I will be interested to see if the language specific elements differentiate between American English and English English, i.e. Color or Colour.
Grab the file I used in the video from here 👉 pages.xelplus.com/custom-formatting-file
Hi Leila for some reason I am not able to download this file. I got the email but when I click on download I am unable to get the file. I tried using two different emails. Can you help please? Thank you
Hi Leila , I am unable to download the workbook. could you please check .
I wanted to extend my gratitude for the excellent job you did in the video on "Four SMART Ways to Use Custom Formatting Instead of Conditional Formatting in Excel." Your explanation was clear and insightful, and it truly made a difference.
You are an Excel evangelist, and your passion for teaching shines through!
Great to hear!
I can’t believe I’m sitting here at home on my own time watching a video about Excel that makes me excited to get to work and see what I can do with Custom Formatting - thank you for a clear explanation, I had never really investigated the power of this tool in the past and can’t wait to see what I can do with it!
Same here 🙌
THANK YOU for being the person to finally De-Mystify the Custom Format options in Excel. For years I have been a little intimidated by how this actually works, but YOU explained it perfectly and in a very useful & time efficient manner. Great job!
Glad it was helpful! Thank you for the nice feedback.
Thank You Leila. You are researching every aspect of MS Excel. Hats off to you.
Wow. I've been curious about custom formatting for a while, AND I've recently been banging my way through conditional formatting. You've literally just saved me hours of work, and opened up a whole new function of Excel that I didn't know existed!
Glad I could help!
I have used excel for 25yrs and you are showing me simple things like the use of the * in custom formatting that I was never aware of.
Bravo!
I'm glad you find them useful :)
The way you speak and clearly say each point and logic......is brilliant.
=If(Now()>0,"Leila is best","Earth has stopped rotating")
😘
A short cut for getting the up triangle and down triangle is, for UP - ALT+30 (on numeric keypad), for down ALT+31 (on numeric keypad). This is quicker and easier to remember than inserting symbols
Thanks so much for this - my Symbols dialog was playing up so could only access normal arrows 🎉
Remember she was teaching syntax, so in this example and ease of understanding without it becoming to overwhelmingly or confusing it was better to use insert symbols. However after the meaning concept was achieve using keyboards would be ideal 🎉
thanks
Thank you for sharing this. It really means a lot in my office work.
I have been using Excel for years and somehow never came across this channel, it's simply amazing.
You are a genius. Words cannot express my gratitude. Much appreciated.
Very well explained with a clear voice. Thank you.
Thank you! I needed to add "+" and "-" in front of some numbers and this was a BIG help!
My respected virtual teacher! The logic of custom formatting always remained a mystery for me, but this video revealed this secret now. Thank you so much. May you live long on youtube to share knowledge for spreadsheet lovers.
You're very welcome!
Fantastic delivery of material. I found your tutorials very helpful. Thank you!
Finally a great explanation about custom formatting! Many thanks for posting helpful tutorials!!
THANKS SO MUCH LEILA. I LOVE YOUR VIDEOS. ITS SO EDUCATING
I'VE BEEN SUBSCRIBED TO UR CHANNEL FOR OVER A YEAR NOW
Amazing information demonstrated with clarity. Thanks so much.
wow -- very nice. i had viewed ~8 vids, avoiding this one with a 'pretty face. turns out, u provided the best content, rhythm in explaining the content, and u explain both, basic and complex processes within the lesson. then i explored the library of great content and viewed your story -- triple wow. great job Leila -- thank you.
Thank you Peter for your kind comment. I'm glad you decided to click!
she has impressive talent to explain complex topics.. respect
Watching more custom videos during COVID! thanks for the refresher video!
This video is a revelation about how good custom formatting can become.
what symbol she write before and after plus
P
أختي الغالية ليلى، شكرا بحجم السماء.
بفضل الله ثم بفضل فديواتك اصبحت استخدم الاكسل - اللي كان شيء يخوف وغامض بالنسبه لي-.
شكرا مره ثانيه وبارك الله فيك.
Keep up the good work
Thank you.
I had taught Excel for years, and knew about the power of custom formatting; but I had only taught it as useful for adding text to numbers, such as "sf" for square foot or "/mth" for per month. I was honestly not thinking I would get a much of a lesson with this video, BUT. I feel like I've been driving my Ferrari custom formatting without every getting out of first gear....I've just enjoyed a thrilling joy-ride with someone who knows how to take that Ferrari and run it thru the gears. Thanks!
Glad you found something useful, Dan!
I wanted to thank you and mention for other viewers that I immediately discovered this also works well with emoji. Win+. (period) brings up the emoji keyboard. Because sometimes a facepalm is the correct symbol.
Beautifully done. The revelation of Excel beauty. Thank you Leila Gharani.
Glad you like it. You're very welcome Peter.
you are one of the best excel tutor in the world.
Dear Miss Gharani,
your lessons are truly EXCEL-lent. Thank you so much for sharing your knowledge with such clarity and generosity.
Thank you Alberto for your comment! I'm very glad you find the content useful. I also learn a lot from the Excel online community here so everyone wins : )
Leila, I was looking for this IF formula and your style just rocks ... solved my headache as simple as it sounds ))) 🔥
wow...never knew that custom formatting could be this effective . and thanks for some good tips .cheers
Oh my word. Why am I so late here. Leila I'm a big fan of yours. The way you present the videos is excellent. You made me believe that I can learn more. I never thought I will learn excel more deeply. But now I guess I can do it.
Thank you so much!
Thumbs up from NL,EU very helpful. clear and calm voice. keep on the good work
Leila, you are a gifted presenter with a beautiful mind.
Thank you! I've been using Excel since first version and use format cell but used conditional formatting because I never took the time to learn custom format. This just saved performance of a large file I'm working on with lots of formatting.
Great to hear Shawn!
thank you for your video's they are awesome.
This video helped me today. thank you Leila.
I'm so glad!
Just amazing. Its like you are doing magic with Excel. Wow.
Glad to hear that :)
You have explained so well Leila! Thank you so much! My excel skill is quite basic and I will continue to watch all the videos that you made and learned them all! Looking forward to seeing more videos from you! You are such a great teacher.
It's great you are dedicated to learning new things. I'm glad to have you here.
Awesome and brilliant. Never seen such simple and useful trick in custom formatting. Way to use compare to conditional formatting. U r super.👏👏👏👏👏
Glad you like it :)
Valuable tip. Thanks for your sharing your knowledge and expertise
I aplode you for your work, you are very dedicated, and your content has been very useful for me, and for many other people I'm sure.
Thank you a lot ❤️❤️❤️❤️
It is simple but very useful in any important presentation. From those small and simple it is helping lectures to influence audiences. Thanks a lot!
I always learn something new in Excel from your videos. Thanks for sharing!
My pleasure David. I'm glad there is something new in there for you.
Thanks Leila, VERY USEFUL VIDEO
Thank you so much for a very informative and straight forward video--
My pleasure! Glad you liked it.
I have been looking for these trick with colors. Thank you so much Leila.
Glad you finally found it :)
Thanks for the video. I am an amateur and u made it all look so simple and ez to do. Thank you
Glad it was helpful!
🤯🤯🤯 Woooow! I've always wondered what those codes meant. And this is super cool! Super easy to understand. Thanks thanks!
It's only last week I've found your channel. And I've been binging since! I've also recommended it to my colleagues 🥰
Excellent, this is very useful. Thanks
this is a fantastic video, I was searching for a proper custom formatting teaching from years... thanks a ton.. :)
Glad you find this useful! You're very welcome :)
Leila Gharani many thanks
Nicely presented Leila, thank you! I am now able to replace Conditional formatting with Custom formatting, so now my monster workbook looks and performs so much better!
Very happy to hear that Bob :)
Best Video explaining Custom Formatting
Glad you think so!
It's really amazing what you can achieve in the Custom section of the Format Cells window. Wasn't aware you could do all that!
I wasn't aware either for the longest time :)
Can you make whole cells a specific colour using this approach? Or do you have to use symbols? Given the performance boost, I want to start using custom formatting where I can - eradicating the need to use conditional formatting.
You'll have to use symbols --- formatting like *█▌ would repeat this symbol till the cell is full and you could color this the way you want...
Your videos much easy understand excel feature thank you...
This is what I have been searching for. Thanks a ton!
I'm learning a lot from you, Beautiful soul.
Hi Leila. i didn't know it could be possible to put a value in opposite side than symbol in the same cell ! thank you for link about the colors.
Glad you found this helpful :)
This was brilliant and just what I needed for work. Thank you so very much! You are the best Leila!
You're so welcome!
Thank you Leila for this training
You're so welcome!
you are a good teacher, i learnt many things through your videos
Thank you! I'm very happy to hear this.
i'm loving this channel every single day !!!!! exactly what I was looking for and the execution from Leila is right on target. Thank you
Awesome! Thank you!
Very very useful function! thank you.
Love your videos Leila. Thank you. Keep it up!!!
Simple & Easy way of Explaination... Thank You
You are most welcome.
brilliant, just brilliant use of custom formatting....
Complicated but simply explained video. Well done.
Thank you. Agree - it takes a while to get a hang of custom formatting....
I love u for this. This is what i need. Thank u so much.
Very well explained with a clear voice. Thank you.
This is so a pleasure to learn from you: first you find topic that is real painful, and with a nice voice, nice pace, and great pedagogy you walk us through.
Thank you very much for this gift.
This is typically something we need in a hurry and don’t know how and why ;-)
wow!~ so simple yet powerful formatting. Really learnt from you. Thanks.
And I must tell you that your voice is so sweet and clear, so comfortable to listen to.
Thank you again👍
You're very welcome. Glad you find the tutorial helpful.
hello from Nepal. thanks for the video.
Really helpful, thanks!
Great video!!! very useful, love you ma'am
Number 2 fit my needs perfectly. Thank you, Leila!
Thank you for teaching this. Was trying to find something good on this subject and found it.
You're very welcome. Glad you find it helpful.
Simply you are AWESOME, I love Excel and watched many videos but this is something really cool.
Wow thank you, very helpful
What better way to be taught, from such a pretty lady 😍 . Thanks you ❤
I like the way you explained excel
Thank you for an excellent tutorial, it was great and easy to follow.
Huh🤔, use excel a lot in office,, still cannot think of what you have done with custom formatting 👌 ... thanks , its amazing ...
Thank you Leila. This is amazing!
Thank you for producing this video, I got advantage a lot from this
That's great to hear! You're very welcome Chanthy.
Thanks for your tutorials! I always learn something new with you. God bless you
Thanks for watching and for your support Dom :)
i did it and its amazing. thanks you so much .
Thanks for your videos!!
Hi Leila,
Your videos and explanations are very nice. Thank you!
Keep going! A.
This is so fantastic! Worth the time viewing this video ! Awesome !
Thank you, I'm really glad you like it!
Thanks Leila Gharani. I am really impressed.
Genuinely interesting video. I had never realised you could use custom formatting in such a way.
You also delivered the information in such a clear and precise manner that it was simple to follow and understand.
I haven’t tried this out yet but I will be interested to see if the language specific elements differentiate between American English and English English, i.e. Color or Colour.
the * space trick was new to me, thanks for that
Dear! i really appreciate your skills in excel.
Impressive how easy you explain it!
Thank you Leila!!
I don't know if I am falling in love with Excel or those big brown eyes 😍. Thanks for the video.
Super useful tips to use in analytical reports!!!!!😁
So interesting and very clearly explained; thank you.
Once again a great eye opener! Thank you.
You're very welcome Ray.
Thank you for your information