Highlight Entire Row a Color based on Cell Value Google Sheets (Conditional Formatting) Excel 

Pro tip, if You want to color a row by checkbox, just enter =$D2:$D, without second equal sign. To the author, Thank You for this video, helped a lot.

It's amazing how I can watch 48975 videos on how to do a simple excel function, and only one can clearly and thoroughly explain the process, and actually WORKS! Thank you!

Oh my goodness, short sweet and simple. Thank you! This helped A LOT! ♥

Perfect! Now I know how to do that in a less complicated way. Thank you!

You made it look so simple and I am grateful

Dude i was trying this for so long, finally found your video and got the solution super quick. Thank you so much!

Amazing, thank-you! Literally the only video I could find that taught me this super handy concept VERY quickly!! Cheers to you!

YO this is very helpful! Especially when paired with Google Forms. This is really awesome. Thank you for this tip. Saves me a ton of time.

Cheers bro! I've was looking all over google before I found this video. Exactly what I wanted.

I have been wrecking my brain for weeks. I have watched so many tutorials and I still couldn't get it. THANK YOU! You created a 2 minute and 35 second video and has blown my mind! Why does everybiody make this seem so diffucult! You have a new subbie!! I wish I could give you a million thumbs up! I will be sharing this channel with EVERYBODY! Thank you! Thank you! THANK YOU!!!!!!

Thanks for the help, I was making a conditional formatting rule for each individual row. Your formula was smart

I have been struggling to figure this out for DAYS. THANK YOU 😭😭😭😭

This is what I was looking for, thanks!

Thank you for this! So helpful.

It looks so easy. Thanks a lot

Excellent .. thanks ! saved a lot of time

Thanks for this. I got it in one go and it in one go. Ive done this sort of thing before, but highlighted text, which isn't a good idea if you want to print to paper, and only applicable to one cell. But highlighting the entire line makes looking through a list easy to spot items that meet my criteria. The only issue I see is when dragging a column, the criteria formula gets messed up.

It was really helpful, thanks for sharing this.

Very helpful, indeed! Do you actually do Fantasy League stuff, or do you pick random topics for your example docs? When I'm discussing things with people on Sheets forums, etc. I often make example docs as if I were an office manager, but I'm almost never doing office stuff... I just don't want to confuse and overwhelm other Doc designers with the intense and specific nerdiness I am working on at the time xD

Thank you so much !! This is super helpful!

It was easy and enough guide, thanks for making this video.

Thanks!! tha was super easy to learn

So helpful, thank you!

thank you so much. This saved hours

thank u thank u 2.5 mins ur a legend

How do I make it work with Color Scale? Lets say I want each row to be more green depending on how high of a number they have.

you the real mvp

Thank you so much. it is very helpful. more power.

I am trying to use this same concept of highlighting a row on a spreadsheet but using greater than for two cells on the spreadsheet. Anyone have any tips on how to make that happen?

Much Appreciated! Any ideas on how to do it with Text Contains" ?

Omg thank you so much! I have been struggling with this for a while now and I know how to do it in Excel but I have to do this one in Google sheets. Thanks so much for saving my ass!

Thanks for the video, is there ant way to do similar thing but for a *text contains* type not exactly a single world ?

love it thank you

Thank You so much.

Is there a way to apply gradient colors for an entire row? 10 levels of priority for example

Does this work with pivot tables too? I can't seem to get it to work.

What to do if you dont want the column C to included in the highlighted region? Pls help its one of my projects

Great help thank you :)

How do you do this is you’re pulling info from another tab

What if the line containing text is more complicated, and the formula should color if the cell contains the text, but is not equal exactly to the text?

Thanks a lot !

Is there a way to highlight a row by just having any data at all in a box? Specifically, I'm trying to get it to highlight by completing a date picker drop down that I have inserted already. So I pick the date, and the row highlights a color.

Thank you!

You are awesome

hy your video help me to save time thanj you. if i have a have column with random notes that i want to mark how i do it ?

Thanks so much !

Nice one!

Thank you 😊

THANK YOU!

How to highlighted with partial match instead of exact match ?

What if the cell I want to trigger the rows is -- if any number is inputted greater than "$0" it changes the color of the respected row.

thanks for the tutorial. really needed it. I tried to make it work, but it only highlights only on the dropdown cell, not on the particular row. How do i fixed this? Please help.

Thank you x)

Thank you!!!

Very Very Thanks

great!

Thanks Bruh

thanks a lot

Brilliant

Very helpful. I have been struggling. Who knew dollar signs was the missing part.

Awesome

Can we do this in MS Excel?

Thank you

that was very helpful. may Allah help you

=$J2:$J=“Not Interested” not working for me. It says Invalid Formula

How to do it when using number value? I can't use the formula with =d1:d="1" for example

Спасибо, полезно

thankyou :)

thanks for the vid! I'm running into a problem where I want the cell to change color if it contains a date - is that possible?

Thanks. Tried this, but referenced a different cell in the formula and it didn't work. Any chance the coding changed for the most recent version of GoogleSheets? Trying to figure out what I did wrong.

thanks

how do i actually HIGHLIGHT THE ENTIRE ROW please? like literaly hightlight it all if it contain a color a word so I can delete it...

Your computer is blazing! What are you using?

Hi, this doesn't work for me, I followed it exactly and it doesn't work. Has anyone else had this problem?

Damn it's not working for me for some reason, even though I've been very precise about the formula.

For anyone trying to do this but wants the cell to only contain the word, not just match it exactly, here is the formula i used (insert your word instead where it says text) =Search("text"; $A1) so if a row in column A contains "text", it will highlight the entire row.

Legand

Well that is not entire row, is it?

Thank you