Excel Conditional Formatting using Formulas

Tqsm sir. Your explanation is on point.

Great

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.

Excellent way of teaching.

Genius

I am using this formula in conditional formatting in office 2019 version
=SUM(B$3:INDEX(B$3:B3,ROWS(B$3:B3)-1))<=B$35
but it throws error like "You may not use reference operators (such as union, intersection and ranges) or array constants for conditional formatting criteria"

However the same formula works fine in 2007 version of excel. Even in 2019 version, when i write the same formula in excel it works, but not in conditional formatting..

plz help

You make hard things look simple

very clear explanation. thank you 🥰

thankyou very much for explaining clearly how to use this, I am truly grateful. It saved a lot of time and research

Thank you very much sir 🙏🙏🙏

Excellent presentation. Loved the way you explained an important excel functionality in simple and precise manner.

Wow man

Osam 👍🏻👍🏻👍🏻👍🏻👌👌👌👌👌

Thank you so much for explaining cf with ease

This is very powerful!

if you want to save time figuring excel you shud stick to this place its realy excellent

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.

Thanks it helps alot

How to formula by color in conditional formatting? Please help

THANKS A LOT RESPECTED SIR

big thanks

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.

Thank You So Much!

nice explanation and was useful

Best👍

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.

THANK U VERY MUCH SIR

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

Very well explained !

Excellent video,

Really very new trick

How to count the number of color after that?

I'm applying these skills to make my checklist item's font turn grey once the task has been completed.

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!

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 😂

Thank you! Very informative and I was able to accomplish what I needed to.

Hi Mr Ram Gopal, where can I view tutorials on formulas?

Great Video !!

This is all I need. Thank you so mucccch!

Excellent explanation

Thanks a ton.. ❤️

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

Dear Ramgopal, Great presentation. How do I contact you over mobile or email?

This was what I exactly looked for. Thanks!

Thank you, great tutorial

Thank u sir. very informative and helpful video.

Sir, you should also give a link to download practice file to follow aloong

Thank You. I found out something new! :)

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?

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 .