ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to highlight the results of a search string in a worksheet? (https://www.excelbanter.com/excel-worksheet-functions/246226-how-highlight-results-search-string-worksheet.html)

raju

how to highlight the results of a search string in a worksheet?
 
Hi,

I am trying to search for a particualr string in a sheet/set of columns. If
a cell contains the search string, i want only the search string to be
highlighted and not the entire cell. how can i get this done?

Please Advice

Pete_UK

how to highlight the results of a search string in a worksheet?
 
You couldn't do this with a formula or conditional formatting - you
would need a macro.

Pete

On Oct 22, 10:52*am, Raju wrote:
Hi,

I am trying to search for a particualr string in a sheet/set of columns. If
a cell contains the search string, i want only the search string to be
highlighted and not the entire cell. how can i get this done?

Please Advice




All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com