Filter by cell color

[PrinceExcel]

In column A I have a data which are filled color with white and red. I want to show the cell with white color only in column B. Any suggestion?

 

[fhqwgads]

add a filter
filter by colour

 

[alansidman]

Here is a VBA solution. I have assumed that when you mean white, that no color has been added.

Option Explicit


Sub WhiteOnly()
    Dim lr As Long, i As Long
    lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To lr
        If Range("A" & i).Interior.ColorIndex = -4142 Then
            Range("B" & i) = Range("A" & i)
        End If
    Next i


End Sub

 

[PrinceExcel]

I fixed it using text to column. Anyway thanks guy.