Problem Statement:
Let us say, I have following columns and their respective values.
A3: Hello
A4: Excel
A5: World

A7: =A3&A4&A5

The output of this formula for example will be displayed in A7 as.

HelloExcelWorld

Now let us say, in a range of cells, there are many formula and some of them refer to contents in A7.

For example, many cells have complex formula and within the formula they have a call to MID function like =MID (A7, 6, 5), which is the substring “Excel” from column A7.

What I want is some way to highlight the substring “Excel” in the actual column i.e. A7.

Contents in A7 should show Excel in Bold Blue colour, and remaining string as is.

So, basically I need some VBA code or macros to find out what all other cells refer contents of A7 and then highlight the contents in A7, which are being referred.

Any help in this regard is highly appreciated.