Grab the file I used in the video from here 👉 pages.xelplus.com/conditional-format-rows
@haqparast4078Ай бұрын
The link is not working
@MrNoBSgiven2 жыл бұрын
Leila, you are a true Goddess of Excel. Same as for others, you demystified the conditional formatting for me today. Thank you.
@dkt221903 жыл бұрын
Your videos have genuinely helped me demystify Excel! You have been that tutor that I was always looking for! Genuinely useful and amazing videos! Please keep doing this. Even your shorts have been extremely useful.
@mpart_woodlathe-stuff9 ай бұрын
Thank you very much Leila. I must've spent 2 days (off and on) trying to get conditional formatting to work. That is, until I saw yours with all the little nuances that were causing me so much grief. Again, thank you
@LeilaGharani9 ай бұрын
Glad it was helpful.
@egasbritesdasilva67733 жыл бұрын
thank you for your video makes my work easier and more fun to read, greetings from us in Dili, Timor-Leste, keep up the good work
@andywrentmore8562 жыл бұрын
I've written excel macros for over 20 years and never knew the tips I learned from this video. Personally, a game changer.
@ldmlhome2 ай бұрын
I’ll never get the 2 hours I spent last week trying to get this to work BUT you have solved the headache that I got from that and I’ll NEVER get this particular headache again. As I’ve stated before YOU ARE THE BEST!!!!!
@richardreid44342 ай бұрын
❤I watch your videos every time I get stuck in a formula and cant thank you enough. You always put the exact solution in to what I am missing. This one you had me remove the “$” from the lookup reference and POOF! Fixed. Thank you so much!!! Love your videos so much.
@sachinrv13 жыл бұрын
The keyboard short cut key for conditional formatting is (well it's not that short cut as such) ALT+H, L then N for conditional formatting new rule, with keyboard select last option "use formula to determine" and then ALT+O for formula bar activity. Using this will make you look like a Pro (hahaha) Thanks for sharing Leila :)
@harishn33313 жыл бұрын
She is unbelievable!!! The is the best example to show how the explanation should be made on a particular topic. Best tutor for excel Thank you Leila
@ogrammer Жыл бұрын
Thank you so much. I was having trouble getting my formatting to apply to the other rows. This was the 4th video I watched and the only one that covered the removal of the $.
@prin45203 жыл бұрын
Just wanted to thank you, your tutorials have been my favorite because you explain things so usefully! ❤️
@charlescaison4376 Жыл бұрын
Your videos have saved me many times. This one included. I am grateful that you are out there making your content.
@LeilaGharani Жыл бұрын
I appreciate that, Charles!
@TheSlarge2 жыл бұрын
A phenomenal piece of work. Thank you.
@new_moon_12 Жыл бұрын
Your video's a life save. Thank you so much. This is such a little bug, but a real big headache. Was literally trying to figure this out for over half n hour.
@djbcybertench3 жыл бұрын
Your tutorials are fantastic ! The right pace and right balance of enthusiasm. I can't see any of your tutorials on Excel cell styles and / or workbook styles (?) I've used these but as always, via your tutorials, I'm probably "scratching the surface" of what could be done. Comments or tutorials welcome...
@LeilaGharani3 жыл бұрын
Wow, thanks David!
@meshell79873 жыл бұрын
Thank you, Leila, for explaining everything so simple and in easy to understand way! Also, your voice is so pleasant, you are not in a hurry, and I can understand everything without the need to give a pause in order to assimilate. You are my favorite excel trainer :) Thank you and keep the same way!
@davidchip6075 Жыл бұрын
I was looking for one solutionf googling the resolution, but after one and a half hour, I found your video and helped me in 5 minutes.... thank you!
@robmoore27802 жыл бұрын
I have been working in Excel now since it first came out and replaced SuperCalc (anyone remember that?). I never could get my head around conditional formatting until I watched this video. thank you so much, it was so simple to follow.
@ryco2000uk2 жыл бұрын
Leila you are so good, you are amazing. nobody explains excel better than you, thank you so much ive learnt bundles
@mezianeremila4543 жыл бұрын
Again it took me months not to say years of practicing to know all these tricks and you compiled it a short 10 mn video, great job as ever thank you very much Leila...
@LeilaGharani3 жыл бұрын
Great to hear!
@andycummings9944Ай бұрын
Thank you, thank you, thank you!!! I had watched three other tutorials before this one, and yours was the first one that I could follow and it worked.
@romeshnixByte Жыл бұрын
i got the benifit of watching this video as i was needing to colour some cells automatically. Thank you so much
@piggyware Жыл бұрын
Thank you, that it starts from the first cell in the selection was an important lesson for me.
@surindersingh_A2511 ай бұрын
Hello ma'am I ve been watching some of your videos for a long. At first it was hard to me to understand, gradually I am understandable to that. Your ideas are advanced at the same time works for me . Now I use the way you say. Thank you so much for creating stuff like that.
@CaseyToland3 жыл бұрын
I always struggled with these and this video made it so much easier to grasp. The trick to copy the formula and drag it across cells to see how it performed was perfect. Thank you.
@TylerStanczak3 жыл бұрын
This is super helpful. Appreciate this tutorial on conditional formatting :)
@LeilaGharani3 жыл бұрын
Glad you enjoyed it :)
@andrevanopstal21432 жыл бұрын
I have been using this method for a long time. The way you explain this is to the point and very easy to understand. Congratulations.
@jimtsai7545 Жыл бұрын
Very clearly explained. Followed the instructions and got it done in one try. 🙏🙏🙏
@w2class3 жыл бұрын
Great clarification of how to apply conditional formatting. Thanks, Leila.
@LeilaGharani3 жыл бұрын
Glad you enjoyed it, Anthony!
@mattschoular88443 жыл бұрын
I have always found Conditional FormTing via formulas to be challenging. This is a great explanation. Nice shout out to Mike Girvin and ExcelIsFun. You both deserve more credit than I can offer with a "Like" and a comment. Keep up the great work, it is appreciated.
@LeilaGharani3 жыл бұрын
Like and a comment is all the credit I need. Thank you for watching!
@yashsharaf88193 жыл бұрын
Thank you Leila, I tried using this the day before but was doing the "fixed cell reference" mistake. then I did the entire thing without formula. Never too late though.... It will be very handy now... Thank you for your contribution...
@LeilaGharani3 жыл бұрын
My pleasure. Hope it will come in handy.
@tapanjayswal10053 жыл бұрын
I always struggling with condition formatting, great help, thanks
@miguelplg194 ай бұрын
Thank you for creating and posting these tutorials. Your knowledge has helped me several times over, and your teaching method is clear and very precise. Thanks again!!!
@ijirving2 жыл бұрын
This just saved me such a headache at work. EXACTLY the problem I was having. Thank you!
@jewelhannathomas Жыл бұрын
Leila, your videos are very easy to understand. Thankyou!
@ghodakesiddhirajkumaradmir256510 күн бұрын
LIFESAVER!! TMR IS MY NATIONAL EXAM
@surajbhardwaj4282 жыл бұрын
Very useful trick... Simple but very useful.... Thank you Leila...🤗👌
@godfredotoo15552 жыл бұрын
I am not only fascinated about how you have explained this lesson, but I am also impressed about your video editting skills. You are awesome.
@Jules-ip1jh2 жыл бұрын
Thanks so much for this, I have been puzzling over this for days, should have come here first! So helpful!
@LeilaGharani2 жыл бұрын
You're very welcome!
@mom48183 жыл бұрын
Leila you are very skilled trainer. I find it hard why would anyone give you thumbs down. Keep up the good work.
@LeilaGharani3 жыл бұрын
Thank you!
@rajeevguj3 жыл бұрын
The row highlight trick was show stopper. Thanks for the tip.
@LeilaGharani3 жыл бұрын
My pleasure.
@hemantbhalsing68232 жыл бұрын
Really helped me. I require this kind of formatting in my workplace. This was super helpful. Thanks a ton !!!
@santhoshsubbiah81202 жыл бұрын
Thankyou so much leila your courses never cease to amaze me, so calm and insightful at the same time
@bestscenes14693 жыл бұрын
This Tutorial is super Helpful. Thanks a lot Leila
@komninoskamamis1098 Жыл бұрын
Just Excellent! Thank you Leila and may God bless you
@LeilaGharani Жыл бұрын
Our pleasure!
@adjarahma7063 жыл бұрын
Best tutorial. I was stoke with my assignment and looking for a clear explanation for the conditional formating using formula and you are the one who explained it very clearly. May ALLAH bless you.
@brazilbeyondtheheadlines5 ай бұрын
This is great, thank you Leila! I can binge watch your channel for hours, I learn so much!
@michaelomosebi63743 жыл бұрын
You probably just saved me my job with this video. Thanks
@LeilaGharani3 жыл бұрын
Glad it was helpful, Michael.
@AhmedAli-uy8el2 жыл бұрын
Very clean and simple your learning method. I have learn very well.
@rohitshukla46523 жыл бұрын
Leila your teaching style and specially your voice both are just amazing
@LeilaGharani3 жыл бұрын
Thank you! 😃
@yogibearstie3 жыл бұрын
With all of the knowledge you have generously shared in so many videos I was able to create drop down lists and date fields in a Word document and then copy them into an Outlook email and save it as a Template. I now have a very reusable form when creating assignments. I couldn’t find these objects within Outlook, but copy/paste works. I bet you would do it 100x smarter though.
@djfmate3 жыл бұрын
Fantastic video. I have recently encountered the same problem you have described here and your explanation of why it occurs is perfect! Thanks Leila. Greetings from David in Australia. 😉👍
@LeilaGharani3 жыл бұрын
Glad the video is helpful :)
@cassioalexan3 жыл бұрын
I wish I knew that when I was learning the basics of Excel, trying to find the correct way to apply this Conditional Format! Thanks, Leila!!
@farhadhossaindu3 жыл бұрын
Thanks for explaining a difficult concept in a step by step approach. Great explanations.
@LeilaGharani3 жыл бұрын
Glad you liked it
@Pygmygerbil883 жыл бұрын
i love Leyla. thanks for sharing knowledge.
@rossanderson52183 жыл бұрын
I had an excel test for job towards beginning of year that had the second conditional formatting you did in, (highlight whole row).. I remember I got completely lost,I even googled trying to workout how and to do it and couldn't find anything to help. I still got the job but I was dumfounded by that question and you've just made it seem so simple! I feel special now haha but thankyou, it is so obvious. bugga! keep up the good work!
@LeilaGharani3 жыл бұрын
Hope I didn't stir up some unpleasant memories 😊
@rossanderson52183 жыл бұрын
@@LeilaGharani haha no not all! all good and now I know for next time :)
@RameeJordanАй бұрын
This is a great tutorial, thank you! I learned a LOT.
@NaveenTamtaIamExcelVBA3 жыл бұрын
No words defining you... you are just incredible.. you are amazaing
@Eibo63 Жыл бұрын
Thank you so much. This was very easy to follow and solved my problem.
@ubaidyaseencubaidyaseenc8207 Жыл бұрын
Truly I was looking for this one today as to get an idea to apply the formatting to the entire row Thanks 🙏🏻
@LeilaGharani Жыл бұрын
Glad it was helpful!
@daecarman673 жыл бұрын
You are my go to for anything Excel. Amazing tutorial. Thank you! This helped my situation.
@walllee6470 Жыл бұрын
Leila Thank you so much for making my life easier by teaching me Excel
@LeilaGharani Жыл бұрын
You're very welcome!
@michaelsmith9352 жыл бұрын
This has always been difficult for me to do. Nice clean solution. Thanks. Great video!
@diggydubb3 жыл бұрын
This was a great help!!! I just could not figure this out. Thanks!!!!
@silverlicious20863 жыл бұрын
Very useful tip. Thanks Leila. Cheers from Loveland, Ohio. (city near Cincinnati)
@sethjuarez3333 жыл бұрын
Love what you do, always concise and helpful. I would love you to add another level to this. Copying the conditional formatting when the second set of data is on another worksheet. Currently, I have to copy numbers and formatting to the second sheet, then adjust manually the cell reference on the second sheet. Is there a trick you could show about managing conditional formats across multiple sheets?
@vijayarjunwadkar3 жыл бұрын
I missed your videos for last 2 weeks due to some work occupancy, but going to watch them soon! And this one of course is best as usual! Your appropriate examples with just enough explanation makes every task so simple to perform! Keep it up! 😊👍
@LeilaGharani3 жыл бұрын
Welcome back! Thank you Vijay 😊
@EvanWil2 ай бұрын
Just used it in one of my sheets. Worked nicely!
@LeilaGharani2 ай бұрын
Great to hear!
@surfer36623 жыл бұрын
Oh dear Leila my teacher ... This is exactly what I am currently looking for !! Thanks a bunch !!
@thomasponniah8848 Жыл бұрын
Thank you. Explained in way that can be easily understood.
@LeilaGharani Жыл бұрын
Glad to hear that!
@tahajasden19482 жыл бұрын
nobody explained the logics behind it but you did thank you.
@kolavithonduraski50313 жыл бұрын
very helpful for highlighting and visualizing the importance of some numbers in bigger sets of numbers 👍 Thanks !
@LeilaGharani3 жыл бұрын
My pleasure!
@jackthegod99882 жыл бұрын
very cool you gave respect when its due to mike girvin . nice video
@SushilShrestha-ur6uw Жыл бұрын
Thank you very much for your informative tutorial.😊
@AccountingandQuickbooks3 жыл бұрын
Conditional formatting is my favourite tool in excel thanks for sharing 👍👍👍👍
@LeilaGharani3 жыл бұрын
Very very welcome!
@abdulquadir9342 Жыл бұрын
Hi Leila, With reference to my query below ... Yes, I found the way do it using $. Thanks, MAQ
@abdulquadir9342 Жыл бұрын
Hi Leila, It has been an absolute pleasure to learn many skills in excel from your lovely tutorials. I have a query and would appreciate very much if you can elaborate and throw some light in solving it. I have a grid with sales people (in rows) and sales totals for each month (in columns). The query is when a particular sales person is selected from a dropdown list to see the performance for a particular month, how can we use conditional formatting to highlight the particular cell that contains the sales value based on the row of the sales person name and the column of the month. Only the cell must be highlighted, not the entire row and column. Appreciate your help on this. Thanks MAQ
@yogibearstie3 жыл бұрын
Thank you. Your video reminded me how to fix some cells with broken conditional formatting formulas. All better.
@hieroglyph3216 ай бұрын
Thanks, this worked for me - and really lovely tips
@vijaygusain1193 жыл бұрын
I knew it already though but the visualising it on the sheet is something new for me...Thanks again and you look lovely as always😇
@LeilaGharani3 жыл бұрын
Wonderful!
@RogerStocker3 жыл бұрын
Fully agreed! I can just copy/paste!
@mohammadashiq99963 жыл бұрын
Thank you Leila, I love the simplicity.
@ritwiksharan40453 жыл бұрын
What a brilliant video. Thanks.
@ibrahimismayilov94893 жыл бұрын
Many thanks Leila! As always very useful.
@devendranarayanverma47263 жыл бұрын
I was really confused before but you have cleared em
@nickotim Жыл бұрын
Thank Leila. This was very helpful.
@megandew64608 ай бұрын
Great video thanks Leila. I'm trying to use conditional formatting in a script in Excel but it tells me "This action currently can't be recorded", am I doing something wrong or can't conditional formatting be used in scripts? Thanks
@xue71593 жыл бұрын
Always love Leila's tutes 👍🏻
@LeilaGharani3 жыл бұрын
Thank you!
@eto56098 ай бұрын
Thanks Laila, it worked.😊
@tt_tinytunes3 жыл бұрын
Hello Leila, great videos you make. I learned a lot form you. Thank you. My question: Is it possible to highlight only certain word(s)/number(s) in cell that contains several words with conditional formatting?
@MistressKuroko2 жыл бұрын
I’m trying to figure out the same thing 😭
@OrvilleCota3 жыл бұрын
Got to learn something new today. Thanks Leila.
@ScotLane5 ай бұрын
Keep up the great work! So helpful, and easy to follow. Thank you so much for your hard work!
@LeilaGharani5 ай бұрын
Thank you! Will do!
@user4742-t9d Жыл бұрын
Thank you Leila for the information🙂
@reserved200611 ай бұрын
I love your videos. I'm using conditional formatting to highlight Payday in a calendar. I also am highlighting the end of the Pay period with a different colour. Occasionally both of these land on the same day. How can I highlight those exceptions with a new colour?
@GearTec Жыл бұрын
@Leila Gharani, your tutorials are best. I have a question, how about conditionally highlight rows of cell that has been changed/updated in last 7 days? It must be possible. many thanks
@artsmith13473 жыл бұрын
This was very helpful. I have found the mysteries of conditional formatting to be confusing for years. Thank you.
@LeilaGharani3 жыл бұрын
Glad it was helpful!
@Ghoopiman Жыл бұрын
Thank you very much i need to takeout the 10% hold back i just found it thanks again 😊
@karlatrujillo11112 жыл бұрын
This was very helpful! Thanks!
@doctorsangeeth Жыл бұрын
@Leila Gharani, you make the most awesome tutorials of any genre. Short effective and beautifully presented. Thanks a lot.