Highlighting the text in cells

[ankur01]

Could anyone please help me in doing this function.

I want to highlight a specific text in number of cells. I have a spreadsheet that contain large data and every cell has big statements and phrases. I want to see specfic words while going thru the spreadsheets. It will save a lot of time of mine.

Can anyone help me this function? Conditional formatting is allowing only to format the complete cell and not the text within it.

For example: I want to highlight "Ankur" in a cell containing the text "My name in Ankur Agarwal".

Thanks in advance.

Ankur

[dilipandey]

Hi ankur,

Welcome to the forum.
Another quick way could be to user search function in another column and using that try searching "ankur" in your original column and if found, you can use "yes" / "no" accordingly like.. =if(isnumber(search("ankur",a1)),"yes","no")... and then you can autofilter data and select all "yes" from the drop down and do your analysis


Regards,
DILIPandey

<click on below 'star' if this helps>

[NickyC]

hi
this macro will change to font colour to red for a word or phrase you enter in the input box, searching each used cell in the active sheet.

Please Login or Register  to view this content.