Forum Discussion
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 highlight or even flag the cell directly above and directly below this word. Thanks
7 Replies
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.
ExcelExciting attached is the sample. Thanks
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.
Riny_van_Eekelen Thanks that's perfect.
Athena219 Glad I could help!
