Multiple Conditional Formatting

Closed
netty - 12 May 2010 à 13:09
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 12 May 2010 à 13:24
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 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 May 2010 à 13:24