Skip to main content

How to Highlight Search Word in Excel with Color

By John Bennet
Got a spreadsheet, full of values/text content and you want to search for a specific word in a row or column then excel with its Find utility(CTRL+F) will let you strike through the search word from the selected position of excel sheet in no matter of time one by one until the last matching search term is found.
But if you want to highlight the search word to filter out the field containing the search term then unlike other tools it doesn't highlight all the search term containing fields by default. For instance: A column with n rows of data like Home Addresses and you want to filter out address fields containing the street name as New Jersey.

Read Also: How to highlight Matching values of other columns in Excel

How to Highlight MS Excel Search Results In Color?
Just follow the below steps to emphasize the search term containing fields in colors of your choice from the color palette.
  1. Open the excel sheet containing the data.
  2. Press Ctrl+A to select for search through the whole excel worksheet (or) select the range of row/column from the excel sheet. Eg: Column A from Row 1 to 100.
  3. Press Ctrl + H to open find & replace the window and enter the search term For example "Jones Street".
    Selected column E to search for the search word "Jones Street" using Find & Replace
  4. Now click Options >> on the find and replace the window to open additional options underneath the same.
  5. Then in Replace with row Enter the same search term as entered in Find what field and then click on Format option under replace with a field to open a new window with formatting options.
  6. In Replace Format window ->Tap to Fill tab and then select any color from the color palette and click on Ok to confirm.
    Fill Tab - Select any color from the color palette and click on OK
  7. Now in Find and Replace window click on Replace All to highlight the search term containing fields with the opted color.
    All excel Cells containing Search term "Jones Street" is Highlighted in Color
  8. Now all the cells containing the search term will be highlighted with the selected color on the excel sheet.
  9. After this, if you want to filter out the search cells separately, press CTRL + Shift + L keys (or) Under the main menu Click on Data ->Filter then Filter by Color.

Labels

Labels:

Comments

  1. AnonymousJune 16, 2018 at 10:26 PM

    My brother suggested I might like this web site.
    He was totally right. This post truly made my day.
    You cann't imagine just how much time I had spent for this information! Thanks!

    ReplyDelete
  2. AnonymousJune 16, 2018 at 10:58 PM

    Wow, marvelous blog format! How lengthy have you ever been running a blog for?
    you make blogging look easy. The overall look of your web site is excellent, as
    smartly as the content material!

    ReplyDelete
  3. AnonymousAugust 10, 2018 at 5:21 AM

    Very nice blog post. I absolutely appreciate this site.
    Keep writing!

    ReplyDelete
  4. AnonymousSeptember 23, 2018 at 2:17 AM

    You really make it seem so easy with your presentation but I find
    this matter to be really something which I think
    I would never understand. It seems too complex and very broad for me.

    I am looking forward for your next post,
    I'll try to get the hang of it!

    ReplyDelete
  5. AnonymousNovember 2, 2018 at 8:00 PM

    Appreciate this post. Will try it out.

    ReplyDelete
  6. AnonymousApril 6, 2019 at 1:30 AM

    Nice answers in return of this question with solid arguments and explaining all on the topic of that.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Disconnect Bsnl BroadBand and Landline Services Online

By John Bennet
Most of the service providers and executives are experts in facilitating the procedures on how to avail the service but will keep their service termination procedures around the corner which will make it difficult for the users to switch on to other networks immediately and easily. Did you know there are people who rely on their faulty landline/broadband connection simply for the complex procedures and time it would take to close the faulty connection? But here in this blog, we have grabbed the termination process from around the hidden corners of the Bsnl portal to facilitate the Bsnl phone disconnection process in simple steps. Note: You can be an existing BSNL customer for years, however, it is mandatory to have an online account registered in the BSNL customer relationship management(CRM) self-care portal to access the online services. If you don't have one, create one by clicking on the below respective links to access your region Bsnl self-care portal for account mana...
Post a Comment
Read more

How to Turn-Off Auto Correct in WhatsApp & Other Messengers

By John Bennet
Dictionary is not only for the people who don't understand the meaning of a word but also used to know the spelling of a word because there are certain words that may phonetically sound the same but spell differently. Using short forms/abbreviated terms during chats is common among teens of this generation for an easy and fast way to communicate and convey information to anyone in contact. Though most of the short forms are auto-added in Messenger dictionary by default but short forms are extended day by day which interfere while typing to project a sentence but eventually auto-corrected to something else by the android keyboard bots. Also Read: How to Play iPhone(.mac) video format files in Android  How to Turn ON/Off Predictive Text While Typing in Messenger? Did you know! Text auto-correction is not a distinctive feature of Whatsapp, the WhatsApp or in any other social messenger's typewriter will be incorporated with either the Android default keyboard ...
Post a Comment
Read more

How to Register and Activate SBI Internet Banking Online

By John Bennet
Internet Banking is the most trusted and efficient way of making transactions, bill payments, view accounts, view statements, deposits and many more facilities that can be accessed from any corner of the world for free. To avail these facilities in SBI (or) any  State Bank Groups new customer's will be given the PPK kit along with the passbook at the time of creating accounts in the bank itself if the internet banking facility request was mentioned in the Account opening form, but for existing customer's they have to register separately to get access to the internet banking either by visiting a branch or without visiting a branch. Also Read:   10 safety tips for secure banking online - That You Must Know If the main motive of internet banking is to ease transactions and payments for clients in the leisure, without visiting a bank home branch in person, then why not to make the registration and activation process of internet banking also in the leisure from their ...
81 comments
Read more