Selecting Rows When Certain values in columns appear sequentially

[cainerj]

Is there a macro or a formula that will search a column for a sequence of values in a column and highlight the rows the belong to?

Example: select rows that cow, chicken and dear appear in sequence.

[tlafferty]

Assuming values in columns A:C:
VBA:

Please Login or Register  to view this content.

Conditional Formatting method:

Please Login or Register  to view this content.

[cainerj]

thanx for the fast response, trying now will respond soon

[cainerj]

It didnt work. I switched the number column to "A" and the column to be searched upon to "C". I used the macros and assigned it to ctrl-j. What am I doing wrong?

[cainerj]

is there away to export the results to another spreadsheet? I have over 50000 rows to scroll through

[cainerj]

anyone know what I may be doing wrong?

[tlafferty]

Can you post a sample of your data along with your modified code?