This is the best video I have seen on the internet for conditional formatting, you have solved all the challenges of conditional formatting.
@danielekstrand70892 жыл бұрын
OMG! I have struggled with this for so long. This is by far THE best explanation I have personally seen. Thanks so much. Definitely a new subscriber.
@arayahomes43083 жыл бұрын
I LOVE HOW you explain the why to us. I love how the why is explained in layman terms, great video and amazing instruction. Keep up the layman speak, it's so useful for everyone and not just techies. Awesome. I definitely am subscribing, you really understand how to teach, which is a rare thing.
@imrachid1 Жыл бұрын
I just wanted to take a moment to say a huge thank you for your help with my Excel problem. Your video tutorial was incredibly helpful and I was able to follow along step-by-step to fix the issue I was having.
@bhakti642 жыл бұрын
whoever is explaining this has very excellent teaching skills. ive seen many videos but this one is most helpful and it solved my problem in least time. i wish i had seen it before , much of my time wudve been saved.
@pv03155 жыл бұрын
Sir .. you are giving out so much more to the world. its really inspiring . your videos are great and next level common sense .
@bhakti642 жыл бұрын
if you want to save time figuring excel you shud stick to this place its realy excellent
@storiesreadaloudforkids2224 Жыл бұрын
thankyou very much for explaining clearly how to use this, I am truly grateful. It saved a lot of time and research
@BajoBeatz23 күн бұрын
Awesome explanation. Short, direct and to the point👍
@PresentationProcess16 күн бұрын
I'm happy you liked the way it was explained!
@rikardsred4 жыл бұрын
Greetings from Brazil :) Thank you very much for your video! It really helped! I applied conditional formatting as you taught here based on a reference cell value. In this way, by changing the value in that specific field the color code follows. So I did 3 formulas: 1.) Go to Conditional Formatting >> New Rule >> Format only cells that contain ... Drop down#1: Cell Value ... Drop down #2: greater than or equals to ... Drop down #3: Clicked on the cell I wanted as reference (ex. =$B$5) ... Format = color green 2.) Then I just replicate the same process for condition 'less than' the cell reference with format yellow color and another condition for when it's 'less than' 0 (Zero) format red color Works like a charm! And now I have more flexibility in my conditional formatting!
@PresentationProcess4 жыл бұрын
Well done Ricardo. That was a great idea. Thank you for watching our videos, and leaving a comment.
@tawandamutingwende56163 жыл бұрын
@@PresentationProcess Asking for assistance on something l am failing to do. I would like to design as follows: 1st column filtering yes/no; second column with due dates; and final column with colours i.e. IF 1st column is No and action plan has passed its due date then column becomes red, IF 1st column is No and action plan has not reached its due date then column becomes yellow; and IF 1st column is Yes a then column becomes green.
@Pingumitu Жыл бұрын
Excellent, this is the video i needed thank you so much!
@sauryatomer24652 жыл бұрын
Excellent presentation. Loved the way you explained an important excel functionality in simple and precise manner.
@c.fiouzi67994 жыл бұрын
Took me days to figure out this free range thing! You ARE THE BEST!
@ravikumar-up1cz2 жыл бұрын
Thank you so much for explaining cf with ease
@PresentationProcess2 жыл бұрын
You are welcome!
@boppudisreenivasarao9094 Жыл бұрын
Excellent way of teaching.
@PresentationProcess Жыл бұрын
Glad you think so!
@lorenaabreu46474 жыл бұрын
Beautiful, clear and precise explanation process
@seherstudios71224 жыл бұрын
Sir ur video is really very informative,plz share more videos of excel im learning it,ur videos will prove to be much helpful for me!!thanks.
@AshokX9856 ай бұрын
Awesome way to make things clear... Thanks for the video...
@pccomputer15503 жыл бұрын
Great explanation , my question is how to make a rule so that the formatting of a cell let's say G4 is determined and changed based on 2 possible word (apple or Orange) in another cell B4 (same row) , and that would be the rule for the entire colomn G and B ?for example if B4 is orange then change the color of G4 to red and if it's B4 is apple then change G4 to green , Much appreciated if you give the answer .
@chrisvale3563 жыл бұрын
Thank you! Very informative and I was able to accomplish what I needed to.
@sivakumarcp67054 жыл бұрын
The way you teaching is awesome with basic error handling Technic....
@lamacumeca9 ай бұрын
New subscriber! Excellent explanation and presentation.
@shrikrishnakadle8209 Жыл бұрын
You make hard things look simple
@jaykay10533 жыл бұрын
New Subscriber! Excellent pacing and vocal clarity. You teach the thinking behind each step, which is something that other tutors are not doing. You also suggest practising writing the formulas, which I think is a great idea. Thank you soooo much!
@Metztlim5 жыл бұрын
Thank you so much for sharing this, I was going bananas not knowing what to do here!
@tanveerabbas32713 ай бұрын
nice one. so if not to be used if single criteria but AND to be used if multiple criteria??@! right?
@charmtabanao6233 жыл бұрын
This is all I need. Thank you so mucccch!
@ramkumargourarajula95284 жыл бұрын
Your teaching is superb and brilliant
@archita9784 жыл бұрын
Such a great video. I have been searching for this exact information and you've made it very easy to follow. So many other online tutorial talk about conditional formatting but never how to set up rules that make the cell color based on two very different columns entries. Thank you!
@ManjushaBasutkar5 ай бұрын
Very clearly explained
@ataraxia.018 Жыл бұрын
very clear explanation. thank you 🥰
@alexasaifi64596 ай бұрын
Great explanation ❤
@abdulazizqureshi22562 жыл бұрын
THANKS A LOT RESPECTED SIR
@seekerofknowledge22484 жыл бұрын
THANK YOU SO MUCH . YOU ARE THE BEST.
@spasbeautiful4 жыл бұрын
HI! Really very well explained. Thank you very much I have 2 questions- How can I color cells in another with information in another sheet? I have a task performed by employees in different offices, how do I color the rows with start date and end date? your help will be of great value. Thanks
@rikardsred4 жыл бұрын
Perhaps in my comments you can find your solution. I was after the same :)
@kankanabanerjee10763 жыл бұрын
thank you very much for this particular video.. i was really searching for this.
@malasubra8362 Жыл бұрын
Tqsm sir. Your explanation is on point.
@HafizTariqJaved3 жыл бұрын
I want to make an excel sheet which i want to follow up all emails records after 3 days if feedback not received then it should change its colors automatically. if feedback received it changes other color. Please help me in this regards
@anthonyshula3642 жыл бұрын
This is very powerful!
@surindersinghgahir62533 жыл бұрын
Thank u sir. very informative and helpful video.
@miltontyotamkwaipo50343 жыл бұрын
This is very useful. I'd like to do the mini course. But I'm in Papua New Guinea. Is it possible to do online training?
@PresentationProcess3 жыл бұрын
Yes of course! All our training is online, and you can access the videos at your convenience. You can find details of our Excel course here: shop.presentation-process.com/p/complete-excel-foundation-course
@volkaner87733 жыл бұрын
This was what I exactly looked for. Thanks!
@creationsoffarzid11544 ай бұрын
How can we represent the following criteria through conditional formatting: I would like to apply a different colour to each different band/range of values eg between a range above and equal to 20 ; then between 20 and 10; then between 10 and 5; and lastly between 5 and 0 ?
@philipLagela2 ай бұрын
Very helpful.. Thank you❤
@tofiqj.buhwihwi4 жыл бұрын
You are the genius keep it up!
@jaykay10533 жыл бұрын
I'm applying these skills to make my checklist item's font turn grey once the task has been completed.
@SentipongLongkumer-mp4dm8 ай бұрын
I have a question what if I want to change the font colour and make the words bold in a bracket. How should I do it?
@JitendraYadav-jv3yx3 жыл бұрын
Great Video !!
@cartoonstoons-q1r3 жыл бұрын
Thank you, great tutorial
@ronlupu2 жыл бұрын
Thank You So Much!
@kalapalanivelu41393 жыл бұрын
Hi Mr Ram Gopal, where can I view tutorials on formulas?
@AshishKumar-xy8dr2 жыл бұрын
Thank you very much sir 🙏🙏🙏
@vinodasari88943 жыл бұрын
Very well explained !
@asmeromtesfai5163 жыл бұрын
THANKS FOR THE TIP I NEEDED IT.
@manikandanb99144 жыл бұрын
Thanks sir interesting class 🙌
@anjana19564 жыл бұрын
sir u r just awesome....i wish i had a teacher like u from school days studies would been more interesting :) can u pls do a video on when to use if , and, or etc functions
@msexcelgooglesheet3744 жыл бұрын
thanks for making this video 🙏.
@Mr.DJArnab3 жыл бұрын
Thanks a ton.. ❤️
@ziabzaheer98714 жыл бұрын
Thank you its very helpfull for me thank you.
@venkatramreddy57073 жыл бұрын
nice explanation and was useful
@santiagobarragan71763 жыл бұрын
VEEEEEERY HELPFUL! Thank you.
@syedsubhani0073 жыл бұрын
Excellent explanation
@klaudiawiduch3 жыл бұрын
Thank You. I found out something new! :)
@PresentationProcess3 жыл бұрын
Happy to help!
@idahmwangi64894 жыл бұрын
Thank you very much for this video. It's quite informative.
@sharukhkhan3172 жыл бұрын
How to formula by color in conditional formatting? Please help
@shewa68294 жыл бұрын
Nice! thankyou so much.
@reggiesmith64234 жыл бұрын
Is there a way to conditional format Black between 0-10, red between 11-33, yellow between 34-79, green between 80-100?
@tanveerabbas3271Ай бұрын
thks. but in the start only b2 should have been in yellow since dollar sign is on both column and row ref.
@abdulbasith54743 жыл бұрын
Excellent video,
@nemranaseem95364 жыл бұрын
Thank you so much bhaiya...really great and simple video...it really helped me on my assignment
@ticlemeu8 ай бұрын
Good tips!
@lalitkumarpandey59119 ай бұрын
Hi, I am struggling to apply the conditional formatting based on other cell values. Kindly help. The case is, in one column I have qtrs. like Q-1, Q-2, Q-3 Q-4 and in other column there are branch codes and these branch codes are repetitive based on some activities. I want to highlight only those cells of branch codes column which are repetitive in that qtr. only. Suppose if I filter out Q-1, it will show only those cells which appear more than once in Q-1 only and likewise in other qtrs.
@sandipanividhyalay-bhatiya90212 жыл бұрын
Osam 👍🏻👍🏻👍🏻👍🏻👌👌👌👌👌
@spacemanstrikesagain4 жыл бұрын
This was useful. Thanks.
@jobanrandhawa48622 жыл бұрын
Thanks it helps alot
@prabhakarann75414 жыл бұрын
Really great, well explained.Thanks
@hardmtnbiker4 жыл бұрын
I’d like to format but with a number range. 90 to 130is green. Over 131 to 140 is orange, 141 to 180 is red and 181 and above is purple. Can that all be under one column?
@HumanityMatters85 Жыл бұрын
I am using this formula in conditional formatting in office 2019 version =SUM(B$3:INDEX(B$3:B3,ROWS(B$3:B3)-1))
@Drkalaamarab4 жыл бұрын
👏👏👏👏👏👏 Brilliant Sir
@k22732 Жыл бұрын
Best explanation
@venkatramana89663 жыл бұрын
THANK U VERY MUCH SIR
@miamited6910 ай бұрын
How to highlight one of three cells with lowest value that are not next to each other?
@priti4kids4 жыл бұрын
Hello Sir. How can we color the Score cells in 3 colors, based on the criteria given if more than 80 then Green color, if between 50-80 then Yellow and if less than 50 the red color. Please help.
@rajeevgosavi45143 жыл бұрын
Sir, you should also give a link to download practice file to follow aloong
@santoshprasad97703 жыл бұрын
Really very new trick
@onion68624 жыл бұрын
Nice video, good job! :)
@elbay24 жыл бұрын
Well done; thank you for the information!
@GeminisArising8883 жыл бұрын
if I understood this, I would have been a NASA cadet ages ago or know my bass fretboard by heart......or worked out meshuggah/ron jarzombek riffs..this is overwhelming
@gloryannmolina32254 жыл бұрын
what if the data is from other sheet. please make video
@bp198703 жыл бұрын
Hi, I have a made a tick sheet but want to create a PASS box when all the ticks have been made. Is this possible? I also want it to be locked so you can't place a PASS in there yourself unless all the other boxes on that row are ticked. Does that make sense? I'm new to excel and I'm boarder line throwing the laptop out the window sometimes 😂
@ninajanelor98774 жыл бұрын
why is conditional formula required to use in creating big excel project?
@praveenvastrad4 жыл бұрын
I WANT TO HIGHLIGHT THE SINGLE CELL IF CELL=5 HIGHLIGHT IN RED ELS HIGHLIGHT IN YELLOW .HOW TO DO
@houstonajaxfl3 жыл бұрын
If I'm trying to highlight multiple cells that contain for example various name codes, how would I apply the conditional format. I.E. =and(a8="azmarc1", a8="azmarc2") I have about 10 codes like this but the formatting isn't working for me. What am I doing wrong. Help!
@lathamuthu8463 жыл бұрын
Dear Ramgopal, Great presentation. How do I contact you over mobile or email?