Excel formula to highlight cells above and below based on text

[Athena219]

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 to highlight or even flag the cell directly above and directly below this word.

Thanks

[#2]

@Athena219 The Microsoft Excel Community