Multiple Conditional Formatting

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have workbook that in column 'CD' contains name of various imports, exports. I would like to make all cells that contain the word imports to be a certain color. My formual in excel is =NOT(ISERR(SEARCH("Exports",CD96))), but b/c I have more that three conditional formatting needs I have to put it in vba code.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768