Copy Row based on yellow highlighting.

[imogul]

I'm pulling my hair out cause I figured this out last year and now I can't find it.



I am given this spread sheet monthly that has conditional formatting applied already. Column B has various notes, and the ones with the word "faculty" are highlighted by conditional formatting.

I need to copy the rows, where cell B is highlighted yellow, into sheet 2. Any help would be appreciated!