Forum Discussion
Athena219
Dec 14, 2020Copper Contributor
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...
- Dec 14, 2020
Athena219
Dec 14, 2020Copper Contributor
ExcelExciting attached is the sample. Thanks
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.
- Athena219Dec 15, 2020Copper Contributor
ExcelExciting Thank you. This really helped.