Highlight certain text in a cell - with varibles

mrpwagner

New Member
Joined
Jul 17, 2016
Messages
22
I have a large excel spread sheet with the following characters repeated: (CD #####). The #### are replaced for different situations. For example one instance might be CD 1-1 or CD 13-5, etc. I have seen that there are VBAs that can be used to color texts but I am looking to HIGHLIGHT the text. I would love some help.

Ideally the VBA would include a the ability to highlight from the open parentheses sign to the close parentheses sign.

Thanks again for your help!!
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,264
Office Version
  1. 365
Platform
  1. Windows
What do you mean by "highlight" the text?
Also are the cells hard values, or formulae?
 

mrpwagner

New Member
Joined
Jul 17, 2016
Messages
22
What do you mean by "highlight" the text?
Also are the cells hard values, or formulae?

The cells are filled with text. Not numbers, not formulas.

I would light to highlight the text in yellow, so black text with a yellow background.



ONLY FOR THE SELECTED TEXT. i know how to color the whole cell. This does not serve my purpose.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,307
Office Version
  1. 2010
Platform
  1. Windows
The cells are filled with text. Not numbers, not formulas.

I would light to highlight the text in yellow, so black text with a yellow background.

ONLY FOR THE SELECTED TEXT. i know how to color the whole cell. This does not serve my purpose.
When modifying the color part for a portion of a cell, you can only modify the text color, not its background.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,587
Members
409,652
Latest member
strangelyangely

This Week's Hot Topics

Top