In Column B I have several instances of the word Category, this instance
could be there 2 or 20 times depending on how much data is retrieved, what I
need to do is to have some code that searches column B and whenever it finds
the word category make the column range B to P bold and have a background
color of blue (for example) for that row, then the code would move on and
find the next instance and do the same thing

any suggestion would be appreciated

Thanks

Nigel