Search box in Excel│create a search box in excel with condition formatting│Excel search box in HINDI

In this video, we use conditional formatting to create an interactive search box to highlight data. This is a nice alternative to filtering, because the information you're looking is highlighted in context, and the search box checks multiple columns at the same time

It is possible to create a search box in Excel, without using VBA?

We will use Conditional Formatting to highlight the fields that match the search string.
In this video, we'll look at a way to create a search box that highlights rows in a table, by using conditional formatting, and a formula that checks several columns at once.

This is a great alternative to filtering, because you can see the information you're looking for highlighted in context.

Let's take a look.

=SEARCH(search_box,$A2&$B2&$C2&$D2)

This formula uses SEARCH to look for text in search_box inside columns A, B, C, and D, glued together with concatenation.

Make sure the row number matches the row of the active cell.

The key to understanding this rule is to remember that it will be evaluated for each cell in the table. The dollar signs lock the columns, but the rows are free to change.

When SEARCH returns any number but zero, the rule will fire and the conditional formatting will be applied.

Now add a light fill that matches the color of the search box, and complete the rule.

The search box is now functional, and orders where the city is "Dallas" are highlighted. You don't have to enter complete words because the SEARCH function just matches text.

There is a problem, though. If we clear the search_box, all rows are highlighted. That's because SEARCH returns the number 1 if the text to find is empty.

You can fix this problem by wrapping the SEARCH function in an IF statement that returns zero when the search box is empty.

For the logical test, use ISBLANK(search_box). If true, return zero. Otherwise, use the original formula.

=IF(ISBLANK(search_box),0,SEARCH(search_box,$C5&$D5&$E5&$F5))

Now, no rows are highlighted when the search box is empty, but the rule still fires when text is entered.

You can use this approach to search as many columns as you like, with all kinds of data.
Let's see in this Video how to do this trick for Phone number,
and our More Video....

HOW to print Excel Document in ONE PAGE - !! workbook printing , EXCEL PRINT with Lines !! - HINDI
https://www.youtube.com/watch?v=0qajDKh7vtA

How to Hide WhatsApp Videos and Images from Mobile Gallery - Nomedia Android WhatsApp Trick - HINDI
https://www.youtube.com/watch?v=TjXatiBzwWU

Mobile Number Validation for 10 Digit, MS-Excel Phone Number Validation Formatting in HINDI
https://www.youtube.com/watch?v=Hk4m9bxNmYY

BHIM UPI APP Download And full Tutorial, !! Unified Payments interface Bank App !! - INDIA
https://www.youtube.com/watch?v=ks-BGcycI-M

How To USE WhatsApp New STATUS - HIDDEN FEATURES FULL IN HINDI Tutorial
https://www.youtube.com/watch?v=GxFZQkdgDik&t

How to SAVE YouTube VIDEOS in Mobile Gallery By Changing URL (Only 3 Step)
https://www.youtube.com/watch?v=MJ4E5dI25MY&t

How to Recharge With PAYTM and FREECHARGE: Full HINDI TUTORIAL step by step
https://www.youtube.com/watch?v=nMLqKziTYvU&t

ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।

आप हमारे चैनल को Subscribe करे।
https://www.youtube.com/channel/UC2k9JH38F3byw92XaFuoPuw?sub_confirmation=1

फेसबुक पर पसंद करने के लिए क्लिक करें
https://www.facebook.com/Comtutor4u/

ट्विटर पर फॉलो करने के लिए क्लिक करे
https://twitter.com/Comtutor4u

-~-~~-~~~-~~-~-
Please watch: "Formatting in MS-Excel For Beginners- !! Hindi PART 2 !! A Comprehensive Guide for Everyone"
https://www.youtube.com/watch?v=mw57wDalfpc
-~-~~-~~~-~~-~-

Видео Search box in Excel│create a search box in excel with condition formatting│Excel search box in HINDI канала ComTutor