View Single Post
  #1   Report Post  
Melkett
 
Posts: n/a
Default Put an if statement according to cell format

I have a spreadsheet with approx. 10000 rows. And i would like to select and
copy the yellow rows and paste them to another sheet. Or delete cells which
are not yellow.

I think that i can do it by putting an if statement in each row and filter
them.
For example, excel will type 1 if the is yellow, else 0. Then it will be
easy to select and copy them. But how?

Or do you have any idea other than "if statement"
I need yor help. Thanks.