Apply Conditional Formatting to an Entire Row - Excel Tutorial

[@cerenademe9433]

A couple of hours and 3 different, confusing tutorials later - I come here and BAM - 4 minutes & done! So easy - Thank you!!

[@Computergaga]

You're very welcome.

[@juanlopez-os3qt]

thank you very much to clarify the concept , you went very fast to the concept avoiding to make many bla bla bla bla, your are a fast consulting in the market. thanks

[@najibshakar3954]

The easiest and most consice video on this topic! Absolutely incredible

[@Computergaga]

Wow, thanks!

[@Miriam-jy7tgz]

This has been the easiest way to highlight the whole row!!!! Thank you.

[@Computergaga]

You're very welcome.

[@andrewhowe4055]

It took 4 minutes to explain what I had been trying to do for an hour. Thank you!

[@Computergaga]

You're welcome Andrew.

[@edouardbey5194]

finally, just the excel video i have been scouring youtube for, thank u for the easy explanation mr gaga

[@plavali_znaem]

Came back to Excel, and Mr. Computergaga is back at my rescue! AWESOME as always!

[@Computergaga]

Welcome back! Thank you Alexandra. You're AWESOME!!

[@theheavenlyheirs]

I have watched 5 different videos and none were helpful for what I needed. This one was simple, easy, and exactly what i was needing to do. Thank you very much.

[@Computergaga]

My pleasure. Thank you.

[@lovinthe1320]

Precisely what I was looking for. Thank you!

[@Computergaga]

You are welcome!

[@nykad21]

This has just helped me loads. Thanks for the clear and simple instructions!

[@Computergaga]

You're very welcome. Glad it helped 😀

[@DJKAILO1]

You're the best! This is what I was trying to do for a long time, finally I know how. Thank you

[@Computergaga]

Thank you. Great to hear.

[@BuddhaSheep]

Hurray! Awesome video! I can finally format an ENTIRE ROW thanks to your very helpful video. Thank You!

[@Computergaga]

Thanks Mike. That is great to hear.

[@jj6276]

Excellent tutorial -- delivered perfectly! To the point, and demonstrated with simplicity. Thanks for this... and yes, I've subscribed!

[@Computergaga]

Thanks Jesal

[@sanjugomra1480]

kzbin.info/www/bejne/g3LNiKOGrMiHkJI Hello 🙏 Please like share & subscribe my Channel.

[@summerlark4593]

Thank you so much! I was struggling with this for so long, and you showed me exactly what I needed to do ($E2 instead of E2). You rock!

[@Computergaga]

You are welcome. Thank you 😊

[@nokpiadariusconstantino1333]

Vsnvsn z

[@praveens8651]

Thank you, clear and to the point!!!

[@Computergaga]

Thank you, Praveen 👍

[@imranandimran]

Thanks so much. Very straightforward and helpful video. I appreciate the way you explain not just how to do it but why and what the relevant code means.

[@Computergaga]

You're welcome, Imran.

[@nooruddinkhawaja7379]

Very simple and easily explained, thanks.

[@Computergaga]

You're very welcome Nooruddin.

[@SusanBailey-gu9qn]

This was the best and easiest by far, thank you

[@Computergaga]

My pleasure, Susan.

[@stevew1047]

Great Information. I watched five other videos before finding this one that made perfect sense!

[@Computergaga]

Glad you enjoyed it! Thanks, Steve.

[@bryankobe9197]

You helped me out with something i have been struggling with for ages now everybody thinks i am amazing at Excel, which i am clearly not. thank you 1000x

[@Computergaga]

Awesome! Happy to help Bryan. You are amazing at Excel.

[@sanjugomra1480]

kzbin.info/www/bejne/g3LNiKOGrMiHkJI Hello 🙏 Please like share & subscribe my Channel.

[@sarahradford9294]

Thank you!!! Finally got my formatting sorted thanks to your clear video ☺️

[@Computergaga]

Excellent! You're welcome, Sarah.

[@MattKlevemann]

Perfect! Just what I needed. Thanks.

[@Computergaga]

Happy I could help.

[@elliottsommerville2227]

Thank you so very much for this lesson. This was GREAT!!!

[@Computergaga]

Glad you enjoyed it! My pleasure.

[@jamiebeattie8852]

Life saver, been trying to figure this out for years!

[@Computergaga]

My pleasure. Glad it helped Jamie.

[@samirshaikh-2405]

Thanks of millions @Computergaga

[@Computergaga]

No worries, Samir.

[@soratoninx]

Good God, THANK YOU!! Simple and easy. I looked up 5 different videos and all of them were poorly explained. Much appreciated

[@Computergaga]

Glad to be of help.

[@excellenceAgbagba]

Omg thank you so much for this video, I have been finding it difficult to learn this and this video just explained this easy , THANK YOUUUUUUUUUU

[@Computergaga]

Great to hear. You're very welcome.

[@ihioloj3342]

Hey bro you dropped this 👑... Thanks!!👋💪💪

[@Computergaga]

💪👍😀

[@brandos8777]

Video length is the perfect time, well done lad.

[@Computergaga]

Thank you, Brando.

[@basarozyilmaz]

Hi man, thanks, this is the video people searching for.

[@Computergaga]

No problem 👍

[@ernestol6325]

You're a genius - This is what I as trying to do! Awesome

[@Computergaga]

Excellent, thank you Ernesto.

[@BattleSymphony349]

Same here!

[@egvNY]

Cheerio !! Excellent !!

[@Computergaga]

Thank you.

[@wayneedmondson1065]

Thanks Alan.. always a pleasure to watch your videos. Thumbs up!

[@Computergaga]

Thank you Wayne.

[@simonkynaston6751]

Cheers mate... Nice and clear and it does help to hear it like I speak!

[@Computergaga]

No worries. Thank you, Simon.

[@stephaniekerry1480]

THANK YOU, SIR, Just and FYI I applied this to Google Sheets and it worked as well.

[@Computergaga]

Excellent! Thanks Stephanie.

[@royhobbs9499]

Thank you very much from San Diego, California

[@Computergaga]

My pleasure Roy.

[@MISTERFANCYPANTS1000]

Excellent and concise. Thank you!

[@Computergaga]

You're welcome!

[@8leggedsquirrel521]

Thank you! Exactly what I needed

[@Computergaga]

Glad it helped!

[@BrownInEurope]

Excellent, thank you!

[@Computergaga]

You're welcome 👍Thanks

[@arenperera6157]

Good Explanation. I did it Thanks. it is very easy.

[@Computergaga]

Great 👍 Thank you.

[@natasharudy9987]

Can this be done on the online excel version? I don't have the same options when clicking on conditional formatting

[@dillibabu7174]

Good and simple presentation

[@Computergaga]

Thank you.

[@emmanuelodei8428]

This was helpful. Thank you

[@Computergaga]

You're welcome, Emmanuel. Thank you.

[@danaredford5782]

Helped me with a spreadsheet, thank you! Great explanation.

[@Computergaga]

Thank you, Dana.

[@alexsushantogomes376]

Amazing!!! Very helpful 🎉🎉🎉

[@Computergaga]

Thank you 😊

[@mohideenthassim7180]

Thank you Alan, great little tip and very useful. Cheers Mohideen

[@Computergaga]

Thanks Mohideen.

[@bhakti64]

very nice explaination, most easy

[@Computergaga]

Thank you so much 🙂

[@88spaces]

Thank you. Your explanation is clear and concise. It helped me to apply my own conditional formatting.

[@Computergaga]

Great to hear. Good work Chris. And thank you.

[@tomasleopoldoriviere7786]

Exactly what i needed, thank you so much! Liked and suscribed

[@Computergaga]

Awesome! Thank you, Tomas.

[@AdeKaryadi]

Nice tutorial, thanks

[@Computergaga]

You're welcome, Ade. Thank you.

[@judytan9062]

It's explained clearly. Thanks much!

[@Computergaga]

You're welcome, Judy.

[@jalaludheenk2672]

Very informative video and you made it simple

[@Computergaga]

Glad it was helpful! Thanks 👍

[@Pri1997]

Good video... I'm from India

[@Computergaga]

Thank you, my friend 👍

[@Pri1997]

@@Computergaga 👍🏻😊

[@MissDaynaN]

Excellent! Thanks for the help!

[@Computergaga]

You're very welcome. Thank you.

[@thomasclark9164]

Straight to the point. Nice work!

[@Computergaga]

Thank you, Thomas.

[@sleddy01]

Cheers, mate. Exactly what I needed.

[@Computergaga]

Excellent! No worries.

[@frankiecao442]

Like your charming accent, thank you for the helpful video!

[@Computergaga]

Thank you! 😃

[@MistressKuroko]

This is exactly what I was looking for! Thank you!

[@Computergaga]

You're very welcome. Thank you.

[@tony23sa]

Thank you!

[@Computergaga]

You're welcome!

[@AliAhmed-ru6jr]

Excellent Tutorial my problem is solved.

[@DeePrastiningtyas]

You are marvellous!! Thanks sooo much. I finally get a solution for this exact problem. Bless you.

[@Computergaga]

You're very welcome Dee.

[@rojaeanglin6164]

Yes I found your vid very useful. Thanks

[@Computergaga]

Excellent! Thank you.

[@hafiimam9470]

Thanks so much for this. Very clear and made extremely simple. Much appreciated

[@Computergaga]

You're very welcome. Thank you Hafi.

[@taybiabrown8655]

Advice (and formula 🙂) would be appreciated! I would like to apply conditional formatting to an entire row when a cell within a certain column is "not blank". The column is just a "free text" field so a specific word or number is not appropriate in this case. Summary of Objective: -- Highlight entire rows in a spreadsheet when there is ANY TEXT in a certain cell of a specific column. Purpose: -- To clearly see (with highlighting) the rows that are no longer "actively in progress".

[@charlesbonfante9188]

Superb Video, really simple. Cheers!

[@Computergaga]

You're welcome. Thank you, Charles.

[@jeffreyfrankel8811]

Thank you, very simple. I want to colour a row when the date in column A is today. Thank you

[@Computergaga]

You are welcome!

[@MummakiRasoi1234]

Thank you very much .

[@Computergaga]

Welcome 😊

[@halimatlawal8455]

Thank you. You helped me greatly with this.

[@Computergaga]

Great to hear, Halimat. My pleasure 👍

[@mansijswarnkar4389]

Wow, Thank you !!

[@Computergaga]

You are welcome!

[@dantekapi5796]

Thank you😊

[@Computergaga]

You're welcome 😊

[@OsamaAbdElAleem]

Perfect .. thank you very much

[@Computergaga]

You're welcome Osama 😊

[@payamsarwar5611]

Thank you so much sir! you have been a great help

[@Computergaga]

Excellent! Very happy to help.

[@EpicBizHero]

Thanks so much! EXTREMELY HELPFUL!!!

[@Computergaga]

Awesome! Thank you ShawnB.

[@ICCY22]

thanks, this was very useful indeed = from new Zealand

[@Computergaga]

You're very welcome. Thank you.

[@shashijayawardhana1034]

Thank you. This is really helpful. 😎🖒

[@Computergaga]

Excellent! You're welcome, Shashi.

[@cananpasa5623]

Thank you. 👍😊✔

[@Computergaga]

Welcome 😊

[@nive-sz7ue]

Thank you so much

[@Computergaga]

You're very welcome.

[@bryanpajenago6744]

Magic is real.

[@Computergaga]

Indeed it is Bryan 😀

[@shojibulvlogs9605]

Thanks a lot.....!!

[@Computergaga]

My pleasure 👍

[@KingKhan-zv1qz]

BRILLIANT

[@Computergaga]

Thank you!

[@irmahersel409]

Thanks, I kept highlight just one column thanks

[@nikhatkamal8908]

Thanks for the video. Unfortunately, when i follow exactly what is instructed here, not only many rows containing my criteria are left without getting the formatting but also I get many other unwanted rows highlighted. I have excel 2016. 'Wondering is this error due to the version I have or what else

[@richdollaz91]

Thank you, helped

[@Computergaga]

Fantastic! You're welcome, Richard.

[@sueinspain6891]

Brilliant exactly what I needed to know

[@Computergaga]

Fantastic!

[@blablo3321]

Very useful

[@Computergaga]

Glad to hear that 👍

[@mikaelmahfouz5941]

You are the GOAT 🤩🤩

[@Computergaga]

Thanks Mikael 😊

[@abulaise07]

really useful to my daily work.

[@sarahmiller6916]

Top notch! Cheers.

[@Computergaga]

Thank you Sarah.

[@drewmccoubrey6014]

Hi thanks for this as its really useful. I have however, ran into a problem on my spreadsheet where the rule highlights the row above the one I've typed the value into. Have you any idea what might cause this?

[@jessaperlada1673]

Im having the same problem

[@joymarieangeles6139]

@@jessaperlada1673 reselect range on "Applies to" and try removing headers cells. For example instead starting at $A$1, try using $A$2 as start cell. It worked for me :)

[@masoodanwer762]

Good very helpful for me

[@Computergaga]

Great to hear. Thanks.

[@darklordgaming3487]

great stuff thankx

[@Computergaga]

Happy to help. Thank you.

[@jLjtremblay]

Thanks a million!!!!! I did this years ago, but I'll be damned if I could remember how. I owe you a beer! Cheers from the Upper Midwest!

[@Computergaga]

You're very welcome. Beer accepted 😀

[@sasavienne]

Very smart. Thanks a lot. 👍

[@Computergaga]

You're very welcome Salim.

[@michaeljoshua8908]

thank you bro

[@Computergaga]

You're welcome, Michael 👍

[@carlosplacido01]

Thanks a lot! The only place where ive found the answer =)

[@Computergaga]

Happy to help Carlos.

[@ladyzeyez85]

Thank you thank you thank you 🙏🏼

[@Computergaga]

No problem 😊

[@FilipeGomesDrummer]

Very useful, thank you

[@Computergaga]

You're welcome Infernalord, thanks.

[@ripfumelosuccessmabunda5131]

Thank you somuch

[@Computergaga]

You are most welcome

[@irisberber3904]

THANK YOU!!! hands down the simplest explanation... I'm trying this same formula for a cell that *contains* a certain text instead of equals, but it doesn't seem to work the same. Can you provide some insight???

[@Computergaga]

Thank you, Iris. For this you can use the following formula - =ISNUMBER(search("Platinum",$G2)) This uses the same example from the video, but for text that contains.

[@moral-immoral-fun]

Thanks a lot

[@Computergaga]

You are very welcome Saikat.