Excel help changing colour of part of a cell?

July 29, 2011 at 01:58:14
Specs: Windows XP

I need to be able to change the colour of all cells in a workbook, between title=" and ", to the colour red.

For example, if I had the following in a cell:
<title="Starting a Business">
it would change
Starting a Business
to the colour red.

Help much appreciated.

See More: Excel help changing colour of part of a cell?

Report •

July 29, 2011 at 09:26:28
re: "all cells in a workbook"

All cells in a workbook or all cells in a worksheet?

In addition, I assume you mean that you want to change all cells that contain <title="text string"> such that the text string turns red.

Can you narrow the range down a liilt bit?

e.g. Are these cells all in a specific column or row or randomly spread out through a worksheet?

Are they all on one sheet or does the change have to made to multiple sheets?

The more detail you provide, the more specific a solution we can offer.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question