VBA Conditional formating for specific text in several columns

  • Thread starter Thread starter johan
  • Start date Start date
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.
 
Back
Top