Skip to main content

Posts

Showing posts from March, 2018

How to Highlight Search Word in Excel with Color

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. Open the excel sheet containing the data. Press Ctrl+A to select for search t