VBA Conditional formating for specific text in several columns

J

johan

Hello,

Is there a VBA code to select several columns and the set several
mentioned text in another color.
For example;
I've got the columns A till Z and a lot of cells are filled with
various text.
I want to format only the written text "aaa" and "bbb" and "ccc" and
"ddd" to the color red.
Al other text in the same cell should keep their original color.
If possible, is there a maximum in columns or rows ? I want to do use
this code for perhaps 40 different text.

regards,
Johan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Excel, Marking a field when text is not like required 2
How do I convert shading to highlighting for specific colors 8
conditional formatting 2
conditional formating in adjacent cells 2
Extract data in rows (with line breaks) to form a table 0
At each change in data apply formula 4
Excel 2003 : conditional format for 5 format settings 1

Top