I have a cell (BB1) that has a symbol (1 to 5 letters, e.g., HUN) that I know occurs 14 times in cells A2:AZ1000. With a macro, a function or conditional formatting, I need those 14 cells to become red. Of course, I will be searching from different symbols in BB1.
Thanks,
Ric