Forum Discussion

Dave12345Elswick's avatar
Dave12345Elswick
Copper Contributor
May 04, 2025

Finding and highlighting based on text in consecutive cells

I have a report that shows changes in status row by row.

I want to highlight 3 cells when there is a specific sequence.

Any time these 3 status follow each other, I want to highlight them.

Dispatched

Job In Progress

Job Complete

 

Sample text is attached.

 

Thank you for your help.

https://docs.google.com/spreadsheets/d/1Wu5mxVoPFpVL6AGSuDJHQzR0GfnR2Tbr/edit?usp=drive_link&ouid=104733884484131341048&rtpof=true&sd=true

Resources