Forum Discussion

Copper Contributor

Dec 14, 2020

Solved

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

Formulas and Functions

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

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!

Resources