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

Athena219

Copper Contributor

Dec 14, 2020

ExcelExciting attached is the sample. Thanks

Example file.xlsx11 KB

ExcelExciting

MVP

Dec 14, 2020

Hi Athena219

Please find attached is solution file, take care of the range selection while making this conditional formatting.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

MSTech.Athena219.xlsx13 KB

Athena219
Copper Contributor
Dec 15, 2020
ExcelExciting Thank you. This really helped.

Forum Discussion

Excel formula to highlight cells above and below based on text

Resources