filtering records based on fill colors possible?

[wavemehello]

hi there,
my worksheet contains staffnames and training completed/not completed which are indicated by different fill colors. If required, can I filter records based on the fill colors? If yes, how?

Thank you
Aj

 

[agihcam]

thru a macro.

 

[wavemehello]

I would highly appreciate if i could get a sample macro codes for example
names are in column A, training name in Column B, status in column C (this column has different fill colors)

 

[agihcam]

sample code;

Sub test()
Dim i As Long
For i = Range("c" & Rows.Count).End(xlUp).Row To 2 Step -1
    If Cells(i, "c").Interior.Color <> vbRed Then
        Rows(i).EntireRow.Hidden = True
    End If
Next
End Sub

 

[wavemehello]

sorry, where does this code go? Do I press Alt F11 then select this worksheet and paste code or create a command button and put the code in on click event? or does it fit somewhere within autofilter?
sorry 4 my ignorance!

 

[agihcam]

hit Alt + F11, right click the vba project, insert module and paste the code there. close the vbe. then from Tools > macro > macros run the code.

 

[wavemehello]

nothing happened

 

[agihcam]

what are those fill color in columnC

 

[wavemehello]

red and green
red=failed training
green=passed the training
I put the pointer and filled the red /green color from the fill color toolbar

 

[agihcam]

does red fill always "failed training" and green fill always "passed the training". if that should be the case, then you can use these cell value as a condition to hide rows.