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!
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!!!!!!
Thank you. No one else of the 5 videos and many google searches indicated to lock down the row by using $D2:$D, so the row in the selected area gets highlighted vs just the first cell
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!
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
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.
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.
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.
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?
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.
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?
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.
I was also struggling to get this and found two easier ways: (1) use "=$D:$D=V" (D is the column, V the conditional value like "active") (2) simply use "=$D1=V" (always 1 after the column letter, no matter where the conditional value is)
Yes, under Conditional Format > Format Rules > there is a Date section where you can change the date criteria. Keep in mind, this will just change a single cell's color, not the entire row
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!
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.
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!!!!!!
Cheers bro! I've was looking all over google before I found this video. Exactly what I wanted.
Oh my goodness, short sweet and simple. Thank you! This helped A LOT! ♥
Dude i was trying this for so long, finally found your video and got the solution super quick. Thank you so much!
Perfect! Now I know how to do that in a less complicated way. Thank 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.
Thanks for the help, I was making a conditional formatting rule for each individual row. Your formula was smart
Thank you. No one else of the 5 videos and many google searches indicated to lock down the row by using $D2:$D, so the row in the selected area gets highlighted vs just the first cell
You made it look so simple and I am grateful
Amazing, thank-you! Literally the only video I could find that taught me this super handy concept VERY quickly!! Cheers to you!
I had to use double quotes instead of single quotes, but this is fantastic!
I have been struggling to figure this out for DAYS. THANK YOU 😭😭😭😭
Thank you! in 2024 my formula didn't like the " " quotation marks. Had to delete them to make it work! Thank you so much:)
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!
It was easy and enough guide, thanks for making this video.
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
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.
thank u thank u
2.5 mins ur a legend
This is what I was looking for, thanks!
Thank you so much. it is very helpful. more power.
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.
Thank you so much !! This is super helpful!
Thanks!! tha was super easy to learn
Hi, this doesn't work for me, I followed it exactly and it doesn't work. Has anyone else had this problem?
i am having this problem too. halp!
How to do it when using number value? I can't use the formula with =d1:d="1" for example
Same! Any solution?
I believe you change it to something like this: =$D2:$D=Value ("1") . This would be where the numerical value you're using is "1"
Choose equal to 1 in drop down list rather than using custom formula.
Brilliant
Excellent .. thanks ! saved a lot of time
Very helpful. I have been struggling. Who knew dollar signs was the missing part.
Dollar signs are always the missing piece ;)
@@hustlesheets LOL
Thanks Mate.
It was really helpful, thanks for sharing this.
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!
Thank you for this! So helpful.
It looks so easy. Thanks a lot
thank you so much. This saved hours
love it thank you
Thanks a lot !
Your computer is blazing! What are you using?
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?
that was very helpful. may Allah help you
=$J2:$J=“Not Interested” not working for me. It says Invalid Formula
$J:$J ✅ $J2:$J ❌
So helpful, thank you!
you the real mvp
THAAAAANKKKK YEWWWWW
Thank you 😊
great!
Thank You so much.
Thanks for the video, is there ant way to do similar thing but for a *text contains* type not exactly a single world ?
Much Appreciated! Any ideas on how to do it with Text Contains" ?
You are awesome
Great help thank you :)
Thanks so much !
Very Very Thanks
Awesome
Nice one!
Thank you x)
thanks a lot
Damn it's not working for me for some reason, even though I've been very precise about the formula.
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 Bruh
Thank you
You're welcome
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 ?
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...
Legand
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.
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?
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.
Is there a way to apply gradient colors for an entire row? 10 levels of priority for example
thankyou :)
What to do if you dont want the column C to included in the highlighted region? Pls help its one of my projects
How to highlighted with partial match instead of exact match ?
Does this work with pivot tables too? I can't seem to get it to work.
thanks
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.
I was also struggling to get this and found two easier ways: (1) use "=$D:$D=V" (D is the column, V the conditional value like "active") (2) simply use "=$D1=V" (always 1 after the column letter, no matter where the conditional value is)
@@MahmoudSdi Thank you so much for your help with this! Greatly appreciate it...
How do you do this is you’re pulling info from another tab
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?
the date changes as well, not the same date. so a date range...? wheels turning, thanks for any help!
Yes, under Conditional Format > Format Rules > there is a Date section where you can change the date criteria.
Keep in mind, this will just change a single cell's color, not the entire row
Can we do this in MS Excel?
how to make that status?
Well that is not entire row, is it?
doesnt work
THANK YOU!
Thank you!!!