Is there any way to make data appear un-highlighted until the search function is used?
@oxpey4473 Жыл бұрын
Following the example of the video you have to put and AND condition on your formula, just only checks if the search box "IS TEXT" it will be drop False when is empty... so it works!!! Here u have the form: =AND(SEARCH($F$3,$C2)>0,ISTEXT($F$3))
@Maidenas059 ай бұрын
Hello !! That is perfect well done ! How can we change , when the SearchBox is empty not to highlight everyting ?
@EamonnCottrell6 ай бұрын
You can do this with and and statement so that it checks if F3 isn't blank too =AND(SEARCH($F$3,$C2)>0,$F$3"")
@xoterra_space Жыл бұрын
Thank you for very helpful video! But what should I do if I want to leave the cell not in highlight when search box is empty?
@CurranOC3 ай бұрын
1. Create another conditional formatting rule and place it before the SEARCH() function's conditional formating. You can drag and drop by using the 4 dots on the left of each conditional format rule. 2. Apply to the same range you are using in the SEARCH() function. 3. Custom formula is... "=ISBLANK($B$1)" . Replace $B$1 with whichever cell your search box is located in. 4. Set formatting style to None or White.
@donk732 ай бұрын
@@CurranOC Thanks for that additional function and for continuing to support your tutorial even though it's several years old.
@saasaaluv10 ай бұрын
thanks for the guideline! Its very easy to understand and helpful
@ProlificOaktree10 ай бұрын
Glad to hear that!
@AdithyaShreshti3 жыл бұрын
This is brilliant, can we do something like this to find different tabs available in one google sheet? I don’t want to get into searching the content in each tabs though
@juantapia33513 жыл бұрын
I've been searching for something similar for weeks. No luck! Please let me know if you're able to find something along these lines.
@asfandyarmalik87409 күн бұрын
Amazing Thank you!!!
@ProlificOaktree8 күн бұрын
You're welcome!
@marksawesomeadventures2 жыл бұрын
This is Click Bait this is NOT a search Box! If you have an Inventory of a Thousand items just "Highlighting" the item ain't gonna make it.
@user-uy4qb7lt6b9 ай бұрын
Hi, This is perfect thank you, is there anyway to get rid of the extra highlighting when there isn't anything in the search box?
@donk733 ай бұрын
I have the same question. If the search box is empty, the entire search field is highlighted
@jj000999able2 жыл бұрын
Hi sir. Thank you for the tutorial. Have one doubt. Can you plz tell how to search multiple text or number in the search box?
@jonlawrance83832 жыл бұрын
Great video, helped me create a search box that works so thanks! The only problem now is that I have a large sheet with thousands of entries and the search doesn't automatically scroll down to the result so I'm scrolling manually looking for the highlighted item. How can I make it scroll to the result automatically?
@ProlificOaktree2 жыл бұрын
Maybe go back to using the control F key combination.
@jonlawrance83832 жыл бұрын
@@ProlificOaktree ah maybe that would be better in that case, shame there isn't a way to display the results as it's satisfying to make something work, but thanks for your help and reply!
@mobi47 Жыл бұрын
search box with vlookup
@2trailertrucker983 Жыл бұрын
@@mobi47 Do you know how to set that up?
@mobi47 Жыл бұрын
@@2trailertrucker983 yes its easy email me
@vianca8113 жыл бұрын
Thanks for this!! It's very clear and easy to follow!
@ProlificOaktree3 жыл бұрын
You’re welcome. Glad it helped.
@JDeWittDIY Жыл бұрын
Thanks for the video, works great! Is it possible to hide rows that do not match the search text?
@ProlificOaktree Жыл бұрын
I don’t think so
@JDeWittDIY Жыл бұрын
@@ProlificOaktree That's a bummer. Thanks for the reply though!
@agoogleuser6937 Жыл бұрын
Yes with a GAS that creates a filter.
@JDeWittDIY Жыл бұрын
@@agoogleuser6937 Thanks. Any more details on how to go about that? What is a GAS?
@sakmberjoshi97811 ай бұрын
THANK YOU SO MUCH SIR REALLY THANKFUL FOR THE INFORMATION !
@ProlificOaktree11 ай бұрын
Welcome!
@bmmusic Жыл бұрын
thank you. needed this.
@ProlificOaktree Жыл бұрын
Glad it was helpful!
@amagdenovski Жыл бұрын
Very helpful, thank you!
@ProlificOaktree Жыл бұрын
You're welcome!
@slimax284211 күн бұрын
thanks you sir
@ProlificOaktree8 күн бұрын
You're very welcome.
@larocque360010 ай бұрын
I was able to get this to work, but it only searches one column. Which is fine. I’m wanting a second box to search the second column, but using the same formula and altering it to match my parameters is not working. Suggestions??
@reading265days23 ай бұрын
Hey! I'm trying to make a search bar for a homemade book catalog. Every time I do this though only some bars gets highlighted, and when I search it gives me a book two bars above the actual thing I am searching for. Is there a way to fix this?
@varuncd10964 ай бұрын
But, it does not filter the data with the same name. In a big raw data, we might need that. Please suggest something.
@TheBookTeller3 жыл бұрын
Thank you
@ProlificOaktree3 жыл бұрын
You're welcome
@shitallohakare93282 жыл бұрын
Wow that's nice, Thank you Sir.
@ProlificOaktree2 жыл бұрын
You are most welcome
@loussaiefraouf3252 Жыл бұрын
please what is the formula to make it search in all of the columns not only in the name column? For example, I want to search with names maybe date maybe amount
@daklaker22873 жыл бұрын
Thank you master!! Would you pls show me how to indicating just only row having data that we search, so how could i do that? Thank you!!
@brazzilianboy Жыл бұрын
Great content, but I have one question, there is any way to put some text placeholder like "type to search" in the search box?
@Kumarmullackal3 жыл бұрын
Thanks a lot. It helped me out !!
@ProlificOaktree3 жыл бұрын
Glad it helped!
@123-o5e2 жыл бұрын
Hello. This is very helpful!! Can we also search for data from a range of cells ? ex. C2 to M1000
@KwinDecipulo Жыл бұрын
THANKS!
@hamjalalsarker1241 Жыл бұрын
Very helpful
@ProlificOaktree Жыл бұрын
Glad you think so!
@nature_through_my_lens Жыл бұрын
Can I add this search box on my google site and it directly shows the result based on the conditional formatting?
@034242024 Жыл бұрын
thank you , you help me you great
@ianmccusker80923 жыл бұрын
Hi Adam, Enjoyed the tutorial thanks. I'm not a coder or anything but I was trying to create a search box facility on my website (like google search) that using Google Sheets could link to an external website that will have over 400 pages. The way I want it to work is the person would type their name in the box and if it was on the Google sheet it would appear in the box and once they clicked on it it would take them to that particular web page. Just wondered if you were able to point me in the direction of where I can find a video where someone explains how to do this. Thanks for your help in advance.
@ConsulthinkProgrammer3 жыл бұрын
Hmm, use Apps Script and build some webApp to recall the particular data from Google Sheets.
@OurTayloredHome3 жыл бұрын
Thanks for the video. Very helpful. How would I need to change the formula if I wanted to search the text of multiple columns instead of just one like in this example?
@OurTayloredHome3 жыл бұрын
Wait! I figured it out. In case you are wondering... =SEARCH($A$2,$B2&$C2&$E2)>0 My search box is in A2 and the fields it searches are column B, C, and E starting on row 2.
@hannah512383 жыл бұрын
@@OurTayloredHome Legend, ty!
@hannah512383 жыл бұрын
The forumla just highlights everything. Do we need to change the '0' to a letter value?
@splatterdaynightmares2 жыл бұрын
Is there a way to do all of this by creating a front end using Google forms? I'm trying to find a cheap, decent database that has a great front end but nothing compares to filemakre pro. I tried the form but it only lets me back in with a link or the spreadsheet itself which is quite infuriating because I'm not sending it to others, it's only for myself. Thanks
@carrietam61212 жыл бұрын
I followed your tutorial but why is it not working for my google sheets?
@malin380jey2 жыл бұрын
can we get a search box to find multiple names at the same time using same box ?
@prashantcreative59013 жыл бұрын
👍.......but how to convert image table into Google sheets
@KeraniganjDhaka3 жыл бұрын
Any way to add search option in google form?
@daklaker22873 жыл бұрын
i cant lock highlight the collumns, can you explain me clearly sir?
@melvinrsmith3 жыл бұрын
This is great and I've got it to work. I must be missing something but when I go back to edit the conditional formula, it doesn't show. It just shows a blank one and no others. Is it hidden somehow? If I want to change it, how do I do it without retyping? Lastly, could I use this formula to search across multiple sheets if the spreadsheet has them? If so, how? Thanks!
@ProlificOaktree3 жыл бұрын
Make sure you highlight the range that is getting the highlighting applied. If you do that first, the conditional formatting rule should show up.
@melvinrsmith3 жыл бұрын
Oh, and when I use this search method, the cursor drops to the cell below the search box. Is there a way to move the cursor back up to the search box so I don't have to move it back up manually each time?
@ProlificOaktree3 жыл бұрын
Not that I know of
@tcz17133 жыл бұрын
This was super helpful, thank you!
@ProlificOaktree3 жыл бұрын
You're so welcome!
@mustakimali836 Жыл бұрын
Tnx
@ProlificOaktree Жыл бұрын
YW
@claudiacolati88103 жыл бұрын
Hi! Love the videos, they are super helpful! I am currently having difficulty with texts moving from their spot whenever I write something above it on Google docs. I have currently began writing a novel and made a table of contents with bookmarks and links to go along with it (with the help of your videos!). I have placed this table of contents as the first page to the document, which will be regularly updated as I write new chapters and add each one to the table of contents. My problem is that because the TOC starts as the first page and the "first page" to chapter 1 starts on the next page, how do I prevent that first page of chapter 1 from moving down every time I add to the TOC? I've tried searching the internet, mostly people suggesting I do a page break, but every time I try using it, it just doesn't seem to work for me (I'm probably just doing it wrong). Thanks in advance for the advice!
@ProlificOaktree3 жыл бұрын
Thank you, I'm glad you have enjoyed my videos. You may want to try a Section Break. See how they can work with custom page numbering here: kzbin.info/www/bejne/nHXUnmdvlMd3bK8
@anitabisht5472 жыл бұрын
It is not working it just moves up and down to different rows but does not find the correct one. Please help sir
@joefromdc2 жыл бұрын
Only isssue I have is how to highlight the box for results and not when the box is empty
@StaceysDogGrooming2 жыл бұрын
is there a way to have a search box on one page, when you search it looks in page 2, but then displays the results on page one?
@demosss57172 жыл бұрын
You can do this by using queries
@syaifulkhusna7299 Жыл бұрын
the formula's is not valid, why?
@rishalchand95103 жыл бұрын
He can we make it possible, if i share this sheet with many people and i only want each person to see their pay only, based on the email they sign in maybe? Or how so others don't enter other employees name and see their pay
@ProlificOaktree3 жыл бұрын
That doesn't sound like something that I would try to do in one spreadsheet.
@rishalchand95103 жыл бұрын
@@ProlificOaktree Please do, looking forward for the video
@andreanicagelacio5202 Жыл бұрын
How to remove the background color and just highlight the one that I search for?
@reasonerkevin Жыл бұрын
I poked around for the same thing and found this to work: =IF ($B$1>$C$1,SEARCH($B$1,$A4)) It's sloppy and requires that C1 block be empty but it does the trick. Basically If your cell has a greater value than the empty cell next to it, do the search. So as the two fields when blank are equal, it won't do the search until you put a value in the field. Hopefully someone will come along and improve this as I'm just learning myself and I'm sure there's a better way.
@oxpey4473 Жыл бұрын
Following the example of the video you have to put and AND condition on your formula, just only checks if the search box "IS TEXT" it will be drop False when is empty... so it works!!! Here u have the form: =AND(SEARCH($F$3,$C2)>0,ISTEXT($F$3))
@vianca8113 жыл бұрын
I have a question! When you delete what's written on the search box, all of the range will still be highlighted right? Then when you do type something, it will just highlight what you've written. Is there a way that nothing will be highlighted until I type something in the search box? Like it will remain its original color.
@ProlificOaktree3 жыл бұрын
That's a great question. I can't think of any way to do that off the top of my head.
@ConsulthinkProgrammer3 жыл бұрын
Use REGEX and IF function to do that
@titunbandhu71743 жыл бұрын
=IF(ISBLANK($F$3)," ",SEARCH($F$3,$C2)>0)
@Tanorov2 жыл бұрын
@@titunbandhu7174 Cheers dude! Saved me so much time!
@oxpey4473 Жыл бұрын
Following the example of the video you have to put and AND condition on your formula, just only checks if the search box "IS TEXT" it will be drop False when is empty... so it works!!! Here u have the form: =AND(SEARCH($F$3,$C2)>0,ISTEXT($F$3))
@gokum79553 жыл бұрын
Second view!!!! Thank you for the info teacher!!
@ProlificOaktree3 жыл бұрын
Welcome!
@NDK03 жыл бұрын
It just says the formula is invalid
@stevensousa56222 жыл бұрын
Awesome but in my case the key cell (F3 in your example) will be empty most of the time. How do I not let it highlight everything when its in its empty state .
@andya60212 жыл бұрын
Here's my solution: Create 2 key cells. Key Cell #1 (F3) is for user input, Key Cell #2 (F4) is the one used by conditional formatting. In Key Cell #2 insert the formula (=IF(F3=0,"@",F3). This means if the input cell (Key cell #1) is empty, Key Cell #2 will be "@" and therefore not trigger the formatting. When the user types a search query into Key Cell #1, Key Cell #2 will mirror it and trigger conditional formatting as intended. (You can use any symbol you want, as long as it won't trigger formatting). You can completely hide Key Cell #2 by changing the font to white
@collaredkeeper2 жыл бұрын
@@andya6021 This is the correct Answer to alot of people's questions regarding removing highlighting! Nice Idea.
@oxpey4473 Жыл бұрын
Following the example of the video you have to put and AND condition on your formula, just only checks if the search box "IS TEXT" it will be drop False when is empty... so it works!!! Here u have the form: =AND(SEARCH($F$3,$C2)>0,ISTEXT($F$3))
@tsuxcreative7335 Жыл бұрын
@@andya6021 Thanks Andy! Believe it or not I've been trying to get rid of the highlight for like 45 min now. lol
@beastrider4839 Жыл бұрын
THIS SEARCH BOX IS SEARCHING THE CONTACT NUMBER???
@ragibnoorantor4172 жыл бұрын
just press ctrl+f, and search
@zubairahmad9256 Жыл бұрын
How can can you tell me plz
@damodarbangalore70033 жыл бұрын
First view and first Comment 👍
@ProlificOaktree3 жыл бұрын
🎉
@selvarajandiappa31432 жыл бұрын
Hi.. Just to check.. can you help us set up..we give you the fields and requirements..we will be happy to pay you for the services
@ProlificOaktree2 жыл бұрын
Thanks for asking, I appreciate the compliment. I don't do individual consulting as my focus is creating content.