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

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

ExcelExciting

MVP

Dec 14, 2020

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.

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.