Hi,

I wonder if there's a formula for detecting a certain pattern in a
particular row or column?

Any of the cells within the range of "start", and "end" would trigger
"do XXX"


Presudo code would be:

If I can see "X" in range(start, end) Then
do XXX
Else
do OOO
End If


Thanks,
Jacky