Excel formula to highlight cells above and below based on text

%3CLINGO-SUB%20id%3D%22lingo-sub-1961558%22%20slang%3D%22en-US%22%3EExcel%20formula%20to%20highlight%20cells%20above%20and%20below%20based%20on%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1961558%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Please%20can%20i%20get%20some%20help%20on%20a%20formula%20or%20a%20way%20to%20highlight%20cells%20above%20and%20below%20another%20cell%20which%20contains%20a%20certain%20text.%20for%20example%20i%20have%20a%20cell%20which%20contains%20a%20word%20%22**bleep**%22%2C%20i%20need%20to%20highlight%20or%20even%20flag%20the%20cell%20directly%20above%20and%20directly%20below%20this%20word.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1962607%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%20to%20highlight%20cells%20above%20and%20below%20based%20on%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1962607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F893080%22%20target%3D%22_blank%22%3E%40Athena219%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fct-p%2FExcel_Cat%22%20target%3D%22_blank%22%3EThe%20Microsoft%20Excel%20Community%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

1 Reply