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 · Accepted solution]

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

[#3]

@Riny_van_Eekelen Thanks that's perfect.

[#4]

Hi @Athena219 

This could be possible with conditional formatting, appreciate if you can please share the sample file with your data and highlight the cells manually that will help us to understand and support you on your query.

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.

[#5]

@Faraz Shaikh attached is the sample. Thanks

[#6]

@Athena219 Glad I could help!

[#7]

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.

[#8]

@Faraz Shaikh Thank you. This really helped.