Excellent. Simple, clear, well modulated, technically right, anticipating doubts & clarifying and above all pleasant. Good teaching is a gift of Nature. God Bless you Leila with all prosperity and long fruitful life.
Leila, another example relevant content, well presented. I've been watching for a while and you have continued to improve in all aspects of your videos. GOOD ON YOU!
Really good one. Total dynamic & no need to use menu command. Formulas give total freedom to organize customized templates. Please show some name manager tricks.
Thanks a lot. Would it be possible to do the same using conditional formatting, but not typing the formula in each cell? Like if you have a massive project plan? Thanks :)
Yes - you can do that with conditional formatting. I'm uploading a video on this in the upcoming weeks, where we conditionally format a cell's number format based on a specific criteria....
Interesting question - Just tested it and yes we can :) Excel is great! We just have to update the font type of the slicer to be the same as the cell font - or alternatively like Michael suggested below we can use unichar and then we can stay in the default font type. That should work too. That gives me a good video idea....thanks for the interesting question.
Hi, you will have to use formulas such as if function, Nested If function or any formula that reference from the first table. Then apply conditional formatting as what was taught. Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too. 4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani Thanks.
Hi Leila, great video. One question: why do I have to ask with an AND-Function in the second part of the formula. I think it would also work just asking for the date. Am I wrong? Greetings from Austria
Hi Rudolf. You are absolutely right. No need for the and inside the 2nd if, because the first If, takes care of the "Y" matches. Formula would then be: =IF(E3="Y",CHAR(80),IF(D3
Fabulous info, but I need help with inserting more than one symbol in a cell. Specifically, the same symbol twice. I have a formula that inserts a symbol, but I'd like to update it so it will double the symbols in the cell. Here's the formula I have. =IF(H17-A17=1,CHAR(129),"") If H17-A17 is between 10 and 18, I'd like CHAR(129) to appear twice. Hopefully, you can help. Thanks so much!
Can u please make a video about getting alert in excel sheet If price move above particular range we need to get alert in different excel sheet Can u make 4 me?
Hi Lelia, I used your video on how to put character on an excel spreadsheet. I changed it up a little and am needing help! I have a column for a follow up date and then i have a column that will show either a check mark when the date is < today date and a telephone when the date is > today date. I am trying to add on here if my column (followup date) is blank to leave formula column blank. Here is my current formula, with D3 being my Follow Up Column and A1 being my Todays Date: =IF(D3A1,CHAR(254)))
Hi Neil - If you use tricks yes. I have two videos coming up that conditionally format WordArt. One uses a little Excel trick (without VBA) and the other uses VBA. Is there any specific shape you'd like to format? Let me know. I like these type of topics....
Leila Gharani I’m building a report which uses four arrows to indicate whether four process milestones have been completed. A simple color change would be a great. What would be even better - and I don’t know if it’s possible, would be to have each arrow indicate the percentage complete as specific tasks within each process are completed. So, if 4/5 tasks were complete, then the arrow would be 80% complete. A bit like a stacked bar chart but applied to a shape. Hope you can help!
Thanks Neil for the explanation. Yes an in-bar chart would be good to use here... and to fully control the control of the shape, regardless of the shape, VBA can be useful. I have similar videos that I'll be uploading in the next weeks that can help you get some ideas....
Hi Leila, Get Video! I was playing with using the Unichar function and I could get most of the symbols (except for the clock but I know it is somewhere. If you use Unichar(9743) and unichar(10003) you'll get similar characters though not exactly the same. These are not impacted by the Font type - they'll show even in Arial. I think you can find all symbols using the Unichar function but it is time consuming because there are over 100000 unicode characters. Thank you for the video, great stuff! Michael
Hi Michael, Thanks for the great input. You just solved one of my problems! It was to get a special symbol for the X-axis and the symbol I wanted wasn't in Arial - I needed the axis font to be Arial though, because of all the other labels! I found it with Unichar! Thank you!
HI Leila, No, thank you for the great video. I always amazed at how you always put a clever spin on everything you do! I knew I had seen those characters somewhere before when I was working with the ASCII symbols. It is rather cool to just insert a column of numbers and drag the unichar character downwards. I tried looking at that unicode sheet that I had created in the custom formatting file but I was to rushed time. As I was playing with the code I noticed that a lot of characters that are showing up in the insert dialog box are there. Really cool stuff!
Hi madam, I am working with Microsoft excel 2003 in my company. I have a question regarding to conditional formatting... If I enter "yes" in A1 cell, the B5, B8, C12, D 15 cells should display as yellow colour filled... Also, if I enter anyother text than "yes", the above mentioned cells like B5, B8, etc... should be displayed as no fill or white filled cell... Pls give a suggestion regarding my issue with condiional formatting in excel 2003...
How do I use say name from list when I enter code I mean like vlookup when I enter code I need name from list at same place throughout Excel. Like say in a2 I enter 5 and right click show me five from list or master
Thanks Bety much, for this, is there a way yo create an animated chart with excel? How to animate mathematics process a a spring performance or a pistón process.how to make animation with imagens in excel ti simulate a process. Sorry if I ask for yo much features 😅, but are doubts that I can kit solve few time a go. thank hoy for yor answer, and best regards
Hi Joe - Yes you can - as long as you can create the chart in Excel, you can animate it using VBA (macros), i.e. you can feed it different data (with the macro) and see the chart adjusting.... I'll add this to my list of future videos.
Hi, thank you for taking the efforts and sharing the concept. I work with a team and we have spreadsheets that is having conditional formatting, it often occurs that people mess up the conditional formatting by using the format painter or copy pasting cell. It seems like excel creates another copy of the rule whenever the cells containing conditional formatting are copied. Is there any way that I could lock conditional formatting without compromising the teams ability to collaborate.?
@@LeilaGharani that's a good suggestion, I'll try it... But is it possible to lock the cells only for conditional formatting but allow users to put in text or even do manual formatting if required.?
Hi. I am wanting make a list where when i watch an episode of a tv series; i need to get: a tick, not seen: a cross & incomplete episode: a - my word for excel to check in a column is "SxxExx" meaning "SO2E04", etc. Could you please give me. Thanks
Good morning, Thanks for posting nice videos. I created conditional formatting for "A" (absent) on my duty schedule........ in the meaning, if any of my team members are not available to take up overtime call, I write "NA" (Not available).... Now the problem I face is the cell is highlighted for "NA" too and it is not desireable......... Is there any way to turn conditional formatting precise to the entry in the cell (means it should highlight only for "A" , not for any other word containing "A"). Thanks
Hi, you can follow video from 08:15 onwards. In the selected cells however, you will input ="A" in that blank follow by what color it would be when it meets this criteria. You can do it for "NA" as the next input as you create another rule for conditional formatting for another color. You can do this for multiple times with different values for different colors until you are done. Do note that the rules of color coding is meant for the selected cells you have click on before inputing the conditions, it is not for the whole excel book. YOu can also try custom formatting which is less messy at the end of the day. Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too. 4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani
Hello dear, my one query is how to many name a column and repeated some 4,5,3,7,2 time how to coloured at once in excel then sort by colour show grouping but every group show different different colour. Please help😂
This channel is great. I love the "Excel magic tricks" guy too, but he stresses me out with his hyperactive voice haha (no offense to him, he's really good).
I just want a SIMPLE how to for Conditional Number Formatting, with both text AND fill colors, for zero, plus and minus, is that too much to ask TH-cam?
Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too. 4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani
there is no option in my TH-cam app on Android phone. actually I. I'm from India and English is not my mother toungue hence I have slightly problem. actually many people like your Excel video when I share on my Facebook page. thanks to reply me. and thanks to make awesome tutorial I heartily appreciate you..
Grab the file I used in the video from here 👉 pages.xelplus.com/cond-formatting-symbols
Let's be honest here, folks. She is a Excell goddess. Thank you, milady!
This is the best excel course ever. Thanks a lot madam
Its so easy that you describe. You always help me. GOD Bless you. Thanks 👍
Excellent. Simple, clear, well modulated, technically right, anticipating doubts & clarifying and above all pleasant. Good teaching is a gift of Nature. God Bless you Leila with all prosperity and long fruitful life.
Thank you so much for the kind words S Peri. I've very glad to hear you find it well presented.
Love it! Copying invisible characters using CHAR to make the spreadsheet look awesome : )
You're welcome :)
Thanks for sharing ,easy to learn
Sister thanks, heartily appreciate you helped me to be a Master in my office without any cent. I want to gift you from my country India.
Excellent video - thank you
I salute you for this video, you are a genius !!
Great example and explanation for personalizing your report .
Thanks Craig.
Your videos are so different from others. I have learned a lot from you , thank you so much.
I'm glad you like the videos! Thank you for your feedback & support.
Thanks a lot professor. I always seek help from you tutorials. Your work is worth appreciating. Stay blessed.
Thanks a lot! Great video!
You are so smart everything you explain makes sense and easy to learn. Thank you for your contribution. I wish you to be a university professor
Thank you for the kind words - but smart is pushing it... I actually do teach at universities :)
Can you give me a clue to use some hyperlink functions for combining Excel and Google map? I tried but its not as good as it was supposed to be
Leila, another example relevant content, well presented. I've been watching for a while and you have continued to improve in all aspects of your videos. GOOD ON YOU!
That's great to hear. Thank you for the feedback!
Looks and brains, Leila got both! Thank you for the help.
My pleasure :)
Really good one. Total dynamic & no need to use menu command. Formulas give total freedom to organize customized templates. Please show some name manager tricks.
خیلی ممنون لیلا جان///
Nice. Very creative.
Please upload such more videos
Simple an understandable... Congratulations
Thank you. Glad you like it.
thanks leila very very good
Thanks a lot. Doing a great job in excel. Please I expect some more in the days to come in VBA. Your knowledge in Excel is superb.
You're welcome Gopala. Yes - a VBA series is still on my list :)
Please. I am waiting eagerly to learn from scratch. Please explain in detail.
Great as always!
Thanks Rosebud.
Thanks a lot. Would it be possible to do the same using conditional formatting, but not typing the formula in each cell? Like if you have a massive project plan? Thanks :)
very good presentation also i am always taking many ideas from this site
That's great to hear! I'm glad you find the content useful.
very informative tutorial
I'm glad to hear that.
That's an excellent tutorial and can help my work alot, thank you.
Can we use different Icons instead of Symbols ?
Thanks a lot profesor, it great solution. But would you main to solve my problem one more. How to auto shrink text in shape ?, Please help 🙏
Thank you
very helpful video thanx☺
You're welcome Farrukh.
It helped a lot, thank you!
Nice video. Just one point: the E3"Y" at 6:38 seems redundant for me, as the IF's formula first condition is E3="Y".
You're right. It's redundant. Thanks :)
Thank you very very much!
You're very welcome Erick.
Can we use conditional formatting in a text box value?
Hi. I would like to know if is possible , maybe with conditional Formatting or custom formatting show in a cell in bold or italics Thanks. Nice Video
Yes - you can do that with conditional formatting. I'm uploading a video on this in the upcoming weeks, where we conditionally format a cell's number format based on a specific criteria....
OK. Thanks for your answer. By the way, nice channel
Pretty cool. Makes me wonder if we could use symbols in pivot table slicers!?
Interesting question - Just tested it and yes we can :) Excel is great! We just have to update the font type of the slicer to be the same as the cell font - or alternatively like Michael suggested below we can use unichar and then we can stay in the default font type. That should work too. That gives me a good video idea....thanks for the interesting question.
Wow💖
U have any video abut adding button with icon and making gurp them??
Hello , Thanks for your effort I just need to know whats is the difference between CHAR (80) and CHAR(137) in your example
Hi Leila, is it possible to create a table that changes colour based on input values in an another table. Thank you so much.
Hi, you will have to use formulas such as if function, Nested If function or any formula that reference from the first table. Then apply conditional formatting as what was taught.
Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too.
4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html
Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani
Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani
Thanks.
Hi Leila, great video. One question: why do I have to ask with an AND-Function in the second part of the formula. I think it would also work just asking for the date. Am I wrong? Greetings from Austria
Hi Rudolf. You are absolutely right. No need for the and inside the 2nd if, because the first If, takes care of the "Y" matches. Formula would then be: =IF(E3="Y",CHAR(80),IF(D3
You're welcome
Hi,
Can You Tell How to change the Rating Iconsets color in conditional formatting.?
Fabulous info, but I need help with inserting more than one symbol in a cell. Specifically, the same symbol twice. I have a formula that inserts a symbol, but I'd like to update it so it will double the symbols in the cell. Here's the formula I have.
=IF(H17-A17=1,CHAR(129),"") If H17-A17 is between 10 and 18, I'd like CHAR(129) to appear twice. Hopefully, you can help.
Thanks so much!
How to add double symbol in conditional formatting
Can u please make a video about getting alert in excel sheet
If price move above particular range we need to get alert in different excel sheet
Can u make 4 me?
Hi Lelia, I used your video on how to put character on an excel spreadsheet. I changed it up a little and am needing help! I have a column for a follow up date and then i have a column that will show either a check mark when the date is < today date and a telephone when the date is > today date. I am trying to add on here if my column (followup date) is blank to leave formula column blank. Here is my current formula, with D3 being my Follow Up Column and A1 being my Todays Date:
=IF(D3A1,CHAR(254)))
wow and how about using symbols in gantt chart progress lines??? ;P
Hey Leila, do you know if it's possible to conditionally format shapes in excel?
Hi Neil - If you use tricks yes. I have two videos coming up that conditionally format WordArt. One uses a little Excel trick (without VBA) and the other uses VBA. Is there any specific shape you'd like to format? Let me know. I like these type of topics....
Leila Gharani I’m building a report which uses four arrows to indicate whether four process milestones have been completed. A simple color change would be a great. What would be even better - and I don’t know if it’s possible, would be to have each arrow indicate the percentage complete as specific tasks within each process are completed. So, if 4/5 tasks were complete, then the arrow would be 80% complete. A bit like a stacked bar chart but applied to a shape. Hope you can help!
Thanks Neil for the explanation. Yes an in-bar chart would be good to use here... and to fully control the control of the shape, regardless of the shape, VBA can be useful. I have similar videos that I'll be uploading in the next weeks that can help you get some ideas....
How did you put the calender?
That's just a screenshot....
thanks
Hi Leila,
Get Video! I was playing with using the Unichar function and I could get most of the symbols (except for the clock but I know it is somewhere. If you use Unichar(9743) and unichar(10003) you'll get similar characters though not exactly the same. These are not impacted by the Font type - they'll show even in Arial. I think you can find all symbols using the Unichar function but it is time consuming because there are over 100000 unicode characters. Thank you for the video, great stuff!
Michael
Hi Michael, Thanks for the great input. You just solved one of my problems! It was to get a special symbol for the X-axis and the symbol I wanted wasn't in Arial - I needed the axis font to be Arial though, because of all the other labels! I found it with Unichar! Thank you!
HI Leila,
No, thank you for the great video. I always amazed at how you always put a clever spin on everything you do!
I knew I had seen those characters somewhere before when I was working with the ASCII symbols. It is rather cool to just insert a column of numbers and drag the unichar character downwards. I tried looking at that unicode sheet that I had created in the custom formatting file but I was to rushed time. As I was playing with the code I noticed that a lot of characters that are showing up in the insert dialog box are there. Really cool stuff!
True - it is really cool stuff! Love it!
hello madam no more show font in excel sheet insert symbol
Hi madam,
I am working with Microsoft excel 2003 in my company. I have a question regarding to conditional formatting... If I enter "yes" in A1 cell, the B5, B8, C12, D 15 cells should display as yellow colour filled... Also, if I enter anyother text than "yes", the above mentioned cells like B5, B8, etc... should be displayed as no fill or white filled cell...
Pls give a suggestion regarding my issue with condiional formatting in excel 2003...
Hi , Do you have any related to the VBA - Mail Merge Function
MSWord,MSExcell & VBA
Please Suggest to me
How do I use say name from list when I enter code I mean like vlookup when I enter code I need name from list at same place throughout Excel. Like say in a2 I enter 5 and right click show me five from list or master
Thanks Bety much, for this, is there a way yo create an animated chart with excel? How to animate mathematics process a a spring performance or a pistón process.how to make animation with imagens in excel ti simulate a process.
Sorry if I ask for yo much features 😅, but are doubts that I can kit solve few time a go.
thank hoy for yor answer, and best regards
Hi Joe - Yes you can - as long as you can create the chart in Excel, you can animate it using VBA (macros), i.e. you can feed it different data (with the macro) and see the chart adjusting.... I'll add this to my list of future videos.
Hi, thank you for taking the efforts and sharing the concept.
I work with a team and we have spreadsheets that is having conditional formatting, it often occurs that people mess up the conditional formatting by using the format painter or copy pasting cell. It seems like excel creates another copy of the rule whenever the cells containing conditional formatting are copied. Is there any way that I could lock conditional formatting without compromising the teams ability to collaborate.?
Can't you protect the cells with conditional formatting or formulas and just leave the cells open for input?
@@LeilaGharani that's a good suggestion, I'll try it...
But is it possible to lock the cells only for conditional formatting but allow users to put in text or even do manual formatting if required.?
Hi. I am wanting make a list where when i watch an episode of a tv series; i need to get: a tick, not seen: a cross & incomplete episode: a -
my word for excel to check in a column is "SxxExx" meaning "SO2E04", etc.
Could you please give me. Thanks
Good morning, Thanks for posting nice videos. I created conditional formatting for "A" (absent) on my duty schedule........ in the meaning, if any of my team members are not available to take up overtime call, I write "NA" (Not available).... Now the problem I face is the cell is highlighted for "NA" too and it is not desireable......... Is there any way to turn conditional formatting precise to the entry in the cell (means it should highlight only for "A" , not for any other word containing "A"). Thanks
Hi, you can follow video from 08:15 onwards. In the selected cells however, you will input ="A" in that blank follow by what color it would be when it meets this criteria. You can do it for "NA" as the next input as you create another rule for conditional formatting for another color. You can do this for multiple times with different values for different colors until you are done.
Do note that the rules of color coding is meant for the selected cells you have click on before inputing the conditions, it is not for the whole excel book.
YOu can also try custom formatting which is less messy at the end of the day.
Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too.
4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html
Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani
Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani
Great
Thank you Eyal.
So you need to take note of the character code ...and the font, to make this work.
Hello dear, my one query is how to many name a column and repeated some 4,5,3,7,2 time how to coloured at once in excel then sort by colour show grouping but every group show different different colour. Please help😂
This channel is great. I love the "Excel magic tricks" guy too, but he stresses me out with his hyperactive voice haha (no offense to him, he's really good).
Have you seen "Hot for Words"? You are "Hot for Numbers"
I just want a SIMPLE how to for Conditional Number Formatting, with both text AND fill colors, for zero, plus and minus, is that too much to ask TH-cam?
Ms Leila has also other videos on using custom formatting rather than conditional formatting You can use that too.
4 SMART Ways to use Custom Formatting instead of Conditional Formatting Part 1 - th-cam.com/video/tGY70sdpaLc/w-d-xo.html
Excel's Custom Number Formatting with Conditions & Symbols Part 2 - th-cam.com/video/faPSXNkU1Y0/w-d-xo.html&ab_channel=LeilaGharani
Excel Custom Formatting with Thresholds & Icons Part 3 - th-cam.com/video/qKpxEl-_IQ8/w-d-xo.html&ab_channel=LeilaGharani
👌🏻👌🏻
I only came here because of the hot thumbnail
could you please speak slowly as I have week English sometimes you speak faster, please it's humble request.
I'll try :) you can also put the video to 0.5 speed....
there is no option in my TH-cam app on Android phone. actually I. I'm from India and English is not my mother toungue hence I have slightly problem. actually many people like your Excel video when I share on my Facebook page. thanks to reply me. and thanks to make awesome tutorial I heartily appreciate you..
Sweet cutie..
Thank You
thanks