Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Conditional formating for specific text in several columns
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Conditional formating for specific text in several columns
Looking here you can modify to suit.
http://www.rondebruin.nl/find.htm On Feb 9, 3:59*pm, johan wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AUTO SUM ONLY SPECIFIC COLORED CELLS BY CONDITIONAL FORMATING | Excel Programming | |||
Formating Specific Text | Excel Discussion (Misc queries) | |||
Conditional formating for data in 2 columns | Excel Worksheet Functions | |||
CONDITIONAL FORMATING FINDING TEXT CONTAINING SPECIFIC NUMBERS | Excel Worksheet Functions | |||
conditional formating a specific amount of cells in a row. | New Users to Excel |