I need to highlight a cell if it contains a key word when the cell contains other words as well.
For example, the cell may contain "(SPECIFICATION) BLOCK DECK HEIGHT"
If the word "SPECIFICATION" appears anywhere in the cell, I need to highlight the entire cell a different color.
Aside from using VBA, is there a way to do this? Thanks.
Bookmarks