I want to be able to change the background colour of a cell depending on its content, I could use conditional formatting but I have more than three conditions.
I have 14 different conditions.
Can someone provide me a generic VBA code to accomplish this.
The content is text rather than a number.
Hope someone can help.
Bookmarks