Forum Discussion
Dave12345Elswick
May 04, 2025Copper Contributor
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
1 Reply
When I click the link, I get "Access Denied".