View Single Post
 
Old 09-27-2011, 10:23 AM
imogul imogul is offline Windows XP Office 2003
Novice
 
Join Date: Jun 2011
Posts: 2
imogul is on a distinguished road
Default Copy Row based on yellow highlighting.

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!
Reply With Quote