Cell turns Red with Matches Symbol

[rwmill9716]

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

 

[Fluff]

With CF Highlight Cells Rules > Equal to > =$BB$1

 

[rwmill9716]

With CF Highlight Cells Rules > Equal to > =$BB$1

Thanks, Fluff

 

[Fluff]

You're welcome