Formatting in excel for highlighting of specific text within a cell

**mig6462** · 06-11-2013, 10:31 AM

hi everyone... i am creating a table and I was wondering if anyone knew if it is possible to have a table formatted so that specific text within that cell automatically highlights. For example:

Stock Number Ref # NUMBER OF FILE
485258714 5443131-89 M0569830261630
676825135 25468731-9 T210367284C024
6864310215 35467981-8 G9304172216013

In this example I want excel to automatically highlight the middle 4 numbers in this 14 number entry. I want it to make the first 6 numbers black, next 4 numbers red, next 4 numbers black. Does anyone know if there is a formula or a way to format this column in excel so it does this for all entries in this column without me having to go through and highlight the changes individually? In this example this NUMBER OF FILE column is column G.

**tigeravatar** · 06-11-2013, 10:44 AM

mig6462,

Welcome to the forum!
Give this macro a try, note that you'll need to change the sheet name to the correct sheet name:

Please Login or Register  to view this content.

How to use a macro:

Make a copy of the workbook the macro will be run on
- Always run new code on a workbook copy, just in case the code doesn't run smoothly
- This is especially true of any code that deletes anything
In the copied workbook, press ALT+F11 to open the Visual Basic Editor
Insert | Module
Copy the provided code and paste into the module
Close the Visual Basic Editor
In Excel, press ALT+F8 to bring up the list of available macros to run
Double-click the desired macro (I named this one tgr)