Put an if statement according to cell format

M

Melkett

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.
 
G

Gary's Student

If you are comfortable with VBA this function:

Function clr(R As Range) As Integer
With R.Interior
clr = .ColorIndex
End With
End Function

will return a number representing the background color of a cell. For
example, if you enter =clr(A1) in a cell you will have the color of the
backgroun in call A1

Good Luck
 
Top