Excel formula to highlight cells above and below based on text

Hi Please can i get some help on a formula or a way to highlight cells above and below another cell which contains a certain text. for example i have a cell which contains a word "**bleep**", i need ...