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 to h...

excel

Formulas and Functions

office 365

Riny_van_Eekelen
Dec 14, 2020
Athena219 Use conditional formatting like in the attached example.

More about that here:
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
bleep.xlsx9 KB

Riny_van_Eekelen

Platinum Contributor

Dec 14, 2020

Athena219 Use conditional formatting like in the attached example.

More about that here:

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

bleep.xlsx9 KB

Athena219

Copper Contributor

Dec 14, 2020

Riny_van_Eekelen Thanks that's perfect.

Riny_van_Eekelen
Platinum Contributor
Dec 14, 2020
Athena219 Glad I could help!

Forum Discussion

Excel formula to highlight cells above and below based on text

Resources