bradnailer
New Member
- Joined
- Jul 27, 2007
- Messages
- 26
Conditional format has only 3 criteria. What I wanted to do is search for a string of text in the cells in column A and if its there, color all the text in the cell <specific color>, bold it & finally increase the size to 12.
I used this in the conditional formatting:
=ISNUMBER(SEARCH("Apple*",A1)) 'blue, bold, 12 font
=ISNUMBER(SEARCH("Berry*",A1)) 'red, bold, 12 font
=ISNUMBER(SEARCH("Egg*",A1)) 'green, bold, 12 font
but I have 12 more to conditional format.
Is someone can show me how to start and finish the macro, I can fill in all the middle info!
Thanks
I used this in the conditional formatting:
=ISNUMBER(SEARCH("Apple*",A1)) 'blue, bold, 12 font
=ISNUMBER(SEARCH("Berry*",A1)) 'red, bold, 12 font
=ISNUMBER(SEARCH("Egg*",A1)) 'green, bold, 12 font
but I have 12 more to conditional format.
Is someone can show me how to start and finish the macro, I can fill in all the middle info!
Thanks